Excel VBA: Formatting Summary WorkSheet cells

[isgamel2]

Hi:

I have a summary worksheet for data contained within 50 worksheets that follow it. The summary page has 50 rows corresponding to the 50 worksheets. The rows count the number of entries there are in each column in its corresponding worksheet. Because of the large amount of data (dates, prices, names) that gets added to the worksheets, it is difficult to find the latest changes.

Ideally, if data within the worksheets were added in the last three days, I would like the summary page sheet cell that changed to be highlighted. Alternatively, I could add a column in the summary worksheet which would show the date of the most recent change in the cell that corresponds to its worksheet.

I tried working with excel formulas but could not find an ideal solution. A problem I ran into was that the dates do not sit in a consecutive range, i.e. columns B,E,F,J, and H contains the dates. The other have numbers, prices. So looking for a Max number is troublesome becasue of the long formula I would have to create for each row.

Does any one have a VBA solution?

 

[SkipVought]

Hi,

You request is rather sketchy. Not much information to go on, is there?

What have you tried so far?

Please post your code.

Please post some sample source data that you are working with.

Skip,

_[red][/red]

 

[isgamel2]

SkipVought:

I do not write code, but I am looking for a VBA solution. Am I in the wrong forum?

 

[SkipVought]

Are you expecting someone to write the code for you? This forum is for people who code or are learning to code to get TIPS.

Maybe you need to hire a programmer/analyst.

"I have a summary worksheet for data contained within 50 worksheets that follow it."

What kind of data is in the 50 sheets?

Do you have a requirements specification for the work that you need to have accomplished?

Skip,

_[red][/red]