PDA

View Full Version : Solved: SOLVED -- Update cells same sheet based on data changes



LLEW1
04-08-2009, 05:36 PM
Hi, posted on this yesterday and got a great result (thanks MaximS)

Have reason now to create further functionality as follows.

The example sheet is updated monthly with financial data in its top secion. Certain elements from the top section are to be aggregated in the month on month aggregate table in the lower part of the sheet.

Im looking to have the sheet update itself from the top half to the lower section, copying down the relvant cells to match the aggregate table in the lower section. In doing this each month I want the previous months data to stay in tact in the lower aggregate table, and for the new months data to be correctly posted to the next months corresponding cell in the aggregate table. A number of subject cells other than the one marked green will be updated this way, but once of have working logic, Ill be able to replicate the code for the other subject cells.
Thanks in advance....

stanleydgrom
04-09-2009, 06:35 AM
LLEW1,

What the triggers the change in cell E8?

Do you run a macro? Is there a formula in cell E8?


Have a great day,
Stan

georgiboy
04-09-2009, 07:08 AM
Something like this maybe?...

Cells.Find(What:=Range("E8").Value, After:=Range("E8")).Offset(, 1).Value = _
Range("C15").Value

Hope this helps

LLEW1
04-09-2009, 04:03 PM
Thanks georgiboy (sorry for late response) - works a treat.

Have a good day.