| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy to next empty row, if not a match
I have the following code to copy data from one sheet to another:
Sheets("CallerInput").Range("B29:BQ29").Copy _ Sheets("InfoLoader").Range("B" & LastRow(Sheets("InfoLoader")) + 1) However, cell B29 in the range to be copied is a date. How can I amend this code to first look down column B of the paste target in "InfoLoader". It would then overtype any day already held, or otherwise paste to the end? Thanks in advance Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and pasting graphs to PowerPoint | Excel Discussion (Misc queries) | |||
| CountIF cells are not empty | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
| copy paste cell character limit | Excel Discussion (Misc queries) | |||
Threaded Mode
