Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to paste data based on condition
I'm new to VBA programming and would appreciate some help with a macro.
There is a database table that can be refreshed throughout the month that simply overrides the cell value from the same refresh. So the values update every time you refresh in the same cell until the next month begins (Date + Year are the column headings). What I need to do is break each month down into weeks like this (1-7 = Week 1, and so on where Week 5 is any day after the 28th of the month). I need a macro where the morning a new week starts (Day 8), I can copy/paste values the entire column in the data table at that moment into another column labeled "Week 1". This process is repeated weekly, with Week 2 = Database Table Values - Week 1 in another column, and so on. Can anyone help me out with this? Was I clear enough with my information? Thanks! Wayne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to copy and paste based on a condition | Excel Discussion (Misc queries) | |||
Copy and Paste based on Condition | Excel Discussion (Misc queries) | |||
Condition based copy/paste of range | Excel Programming | |||
Condition based copy/paste of range | Excel Programming | |||
Macro to automatically paste a pic based on a certain condition | Excel Programming |