Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Date and Paste Data
I have two worksheets. One is called Calendar and the other is called Ghost.
Calendar is a sheet with dates in Columns B-H and J-P (1 week each). The first dates are in row 4, but after that the rows with the dates appear in different intervals. Ghost is a hidden sheet I populate with data from another sheet. In Ghost Column C is dates and column F is data I want to display on Calendar. What I would like to happen is when information is added to Ghost the code will go to the calendar find the associated date on the calendar that matches the Ghost data and date and put the data in the first empty cell underneath the date on Calendar. Advance warning I am not an expert on VB so please be gentle. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find last row of data and paste | Excel Programming | |||
Find next empty row & paste data | Excel Programming | |||
Find matching date in another worksheet, copy and paste data | Excel Discussion (Misc queries) | |||
Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
I need to find a macro to find data cut and paste to another colu. | Excel Programming |