Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro to update information if date changes
using Exel 2000..
I want excel to compare dates on two seperate worksheets and if the date on the first is greater than the second to insert rows and than copy cells on the second to different cells also on the second page. ie..main sheet date is 11-05-08 compared to sheet2 date is 11-04-08...insert cells at a21:d21 and shift cells down (on sheet2) then copy cells b13:h13 to a21:b21 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro to update information if date changes
The description seems a bit inconsistent, but here is a shot
With Worksheets("Main Sheet") If .Range("A1").Value Worksheets("Second Sheet").Range("A1").Value Worksheets("Second Sheet").Rows(21).insert .Range("B13:H13").Copy Worksheets("Second Sheet").Range("A21") End If End With -- __________________________________ HTH Bob "Wundrfulthing" wrote in message ... using Exel 2000.. I want excel to compare dates on two seperate worksheets and if the date on the first is greater than the second to insert rows and than copy cells on the second to different cells also on the second page. ie..main sheet date is 11-05-08 compared to sheet2 date is 11-04-08...insert cells at a21:d21 and shift cells down (on sheet2) then copy cells b13:h13 to a21:b21 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update information | Excel Discussion (Misc queries) | |||
How do I automatically update the same information several cells? | Excel Worksheet Functions | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Auto update of cell information | Excel Discussion (Misc queries) | |||
Automatic update of information in a spreadsheet | Excel Discussion (Misc queries) |