| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Cell in first blank column of a row
I have code that copies a range from worksheet1, selects worksheet2, then
finds the last row of data and pastes the new data into the first blank row. What I need now is to copy data from worksheet3 (in a different workbook), find the last row of data in worksheet2 and paste the data into the first blank column at the end of the last row of data. In essence combining data from worksheets 1&3 into the next blank row of worksheet2. Thank you -- dhunter43 The Performance Advantage, LLC |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select Cell in first blank column of a row
You do it just like WS1, only you chant the references to
Workbooks("DifferentOne").worksheets(3).Range("Ran geToCopy"). "dhunter43" wrote: I have code that copies a range from worksheet1, selects worksheet2, then finds the last row of data and pastes the new data into the first blank row. What I need now is to copy data from worksheet3 (in a different workbook), find the last row of data in worksheet2 and paste the data into the first blank column at the end of the last row of data. In essence combining data from worksheets 1&3 into the next blank row of worksheet2. Thank you -- dhunter43 The Performance Advantage, LLC |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select Cell in first blank column of a row
I thought so except the data from worksheet3 is overwriting the data from
worksheet1 in columns "A:F" instead of going to the first blank column "AG" and populating the data there. -- dhunter43 The Performance Advantage, LLC "JLGWhiz" wrote: You do it just like WS1, only you chant the references to Workbooks("DifferentOne").worksheets(3).Range("Ran geToCopy"). "dhunter43" wrote: I have code that copies a range from worksheet1, selects worksheet2, then finds the last row of data and pastes the new data into the first blank row. What I need now is to copy data from worksheet3 (in a different workbook), find the last row of data in worksheet2 and paste the data into the first blank column at the end of the last row of data. In essence combining data from worksheets 1&3 into the next blank row of worksheet2. Thank you -- dhunter43 The Performance Advantage, LLC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
| Select all cells in a column up to a blank cell | Excel Programming | |||
| I want to select the first blank cell in column A | Excel Worksheet Functions | |||
| Select through last non blank row in a column | Excel Programming | |||
| Select blank cell | Excel Programming | |||
Linear Mode
