Copy the following code in Thisworkbook module. This will record any cell change in the cell comment.

Const gc_intMaxCmtHistory As Integer = 4 'Max Comments History allowed

Dim PreviousValue

read more

Hi Vishesh

Attach is the sample file you where looking for. I have add comment on the document if anybody else want to have a look at this as well.

Thank you
WesleyM101

Hi

I am looking to add tick boxes into a macro. It needs to work like this. for example a product header eg. R1006-TIM and below that are going to be sub headers for example. GSN and when you click on the button the GSN documentation will open but the problem that i have is that there is different GSN docs for different parts of the same item.

read more

Hey

I am looking to put a search box into a excel macro that i am busy writing.

I have a page with different years from 2009 until 2013. if you click on any of them they will take you to that page and all the items of that year is displayed.

Now i want to add the search box on the page with all the dates to help people to get information but if they do not know which year it is in.

Can you please help me with that.

Thank
Wesley

Need help to change the following Excel Macro (VB) code to perform find of value $ in Column A,then copy to ColumnB and fill down where there is used cell data in Column A until Blank cell is reached. There are 1703 occurrences of $ in Column A and a total line count of 60959 (includes variable data and blank empty cells). I have also attached a small sample of what I am seeing with two different options for what I'd like to see as my output. You can assume that value $ is the header and it needs to be prefixed to the data below it, until another occurrence of $ is reached.

read more

Follow these steps to create a pivot table from multiple sources (same of other file). See attached example file.

Steps :
1a In Excel 2003 open the PivotTable and PivotChart wizard by choosing Data -> PivotTable and PivotChart Report.
1b In Excel 2007, press Alt+DP, then type P to open the wizard as there is no equivalent menu option.
2 Choose Multiple Consolidation ranges
3 Open file B as well
4 Choose relevant page field option
5 Simply select and add the ranges (highlighted cells) from this and other file. You can choose to have as many files (A+B)
6 Select New Sheet & Finish

I have a spreadsheet with Prices in one column and Lowest Prices in another column.
At the moment I have 100 instructions like this:
If Range("d4") < Range("i4") Then Range("i4") = Range("d4")
through to
If Range("d100") < Range("i100") Then Range("i100") = Range("d100")

I know there is a better way using If statements and looping through the cells.
Can I find the syntax or an example of how to do this - NO!
Is there anyone out there with the solution? Any help would be really appreciated.
H

Here is the example with notes attached

Hey

I need to copy data from sheet E-1 and past it on sheet Overdue.

The data that i need to copy shows have a value between -1 and -1500 and is in column Z. it needs to copy that entire row to sheet Overdue.

I want to create a button so that everyday i can update that data.

The other problem is that i am going to add remarks net to each overdue item and when i update the data everyday the remarks will not correspond to the origanal row. The reason why i am saying this is because items will be added and removed on the overdue schedule on a daily bases

read more

I can't figure out how to do this except for the very long way. I have a column of about 100 numbers that I want to add. That I can do simply enough, however instead of just showing the final total at the bottom I want to show each step of the way. For example if I'm adding a column of 5 5's in the column next to it i would like to show 5,10,15,20,and lastly 25 at the end. Besides creating a seperate SUM function including the last cell, last two cells, last three cells.....and so on is there a short way of doing this?

Thank you in advance

Sir,

Please any one help me i need change row headings i.e, A B C D E F etc., i need to add DATE CHQ NO. AMOUNT etc.,

attachement is enclosed for your's ready reference.

I have an composite array of data in my Worksheet. I am using a Vlookup function to process the array for various algorithms which require data from the array. The composite array is horizontally divided by three rows of irrelevant data ("IR Data") into two arrays (upper and lower) which requires that the Vlookup function be initialized differently in the upper and lower array; i.e., the starting row of the lower array (below the IR Data) changes with varying output that populates the array.

read more

This is the solution to blog on url
http://excelexperts.com/help

Please see attached xl file.

I'm new at using Excell. I'm trying to assign a numerical value to a letter in my spreadsheet.Can you walk me thru step by step? Or do you have a Video? Thanks

VENDORS PAYMENT DETAILS

1 2 3 4
SL.NO IN FAVOUR AMOUNT THROUGH

1 ABC LTD 30,000.00 DD
2 XYZ PVT LTD 25,000.00 CHQ
3 ZYX LTD 15,000.00 DD
4 CBA SOLUTIONS 2,000.00 CHQ
5 SOMU 8,000.00
6 RANI 6,000.00
7 RANGA 5,400.00
8 RAMANA 56,000.00

Sir

in above table i need to fill in 4th row only DD or CHQ not other characters of any like RTGS, Netbanking etc., how it is possible (details given in attached xls file)

Following are two functions to Export to and Import from Tab delimited Text file.

read more

Sir

How to apply Hyperlink from Word to Excel 2007

VINOD

I have been asked to create a training spreadsheet at work that is to be colour coded to individual levels. I have entered the below VB string but have used educational guesses so far as I have no training in VB.

At present the Sheet cells have a validation list where members of the team can only select 1 of 5 skill set options, however the background colour does not automatically update unless you actually activate the cell after making your selection. Can you please advise how I can get this to automatically update with each change?

read more

Sir/s

I am trying to apply VLOOKUP formula from Anil to 19 (a to b)but it is getting only 71 not 19 but i need 19 how it possible or any other way.

a b

ANIL 71
ANIL 19
BABU 24
BABU 67

VINOD

Sir

I have one prob

a b c d

GANGAWATER BOTTLE TIN POCKET
GANGAWATER TIN BOTTLE POCKET
GANGAWATER POCKET TIN BOTTLE (this is master data)

I am trying to apply VLOOKUP a-b VLOOKUP is getting only BOTTLE(b) not for TIN and POCKET i need to pickup TIN how it is possible or any other root is there.

sir any one help me.

VINOD