| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select copy paste into new book incrementing rows
It's probably been asked a hundred times, but I am still having a hard time
figuring out based on going through others posts. I need a range (say AA3:AB3) to be copied, another file to be opened (we can call it Data.xls) and the range pasted into the next blank row and the file closed. etc. I'm having issues with the "next blank row" part of it. What's the easiest way to achieve this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select copy paste into new book incrementing rows
Hi mike
See http://www.rondebruin.nl/copy1.htm Try this example What if the Database sheet is in another workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mike" wrote in message ... It's probably been asked a hundred times, but I am still having a hard time figuring out based on going through others posts. I need a range (say AA3:AB3) to be copied, another file to be opened (we can call it Data.xls) and the range pasted into the next blank row and the file closed. etc. I'm having issues with the "next blank row" part of it. What's the easiest way to achieve this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select copy paste into new book incrementing rows
There's enough there for me to get the job done.....Thanks! I should have
checked your stuff first.... =) "Ron de Bruin" wrote: Hi mike See http://www.rondebruin.nl/copy1.htm Try this example What if the Database sheet is in another workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mike" wrote in message ... It's probably been asked a hundred times, but I am still having a hard time figuring out based on going through others posts. I need a range (say AA3:AB3) to be copied, another file to be opened (we can call it Data.xls) and the range pasted into the next blank row and the file closed. etc. I'm having issues with the "next blank row" part of it. What's the easiest way to achieve this? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select copy paste into new book incrementing rows
Next blank row in column A
Dim rng As Range Set rng = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 13:53:02 -0700, mike wrote: It's probably been asked a hundred times, but I am still having a hard time figuring out based on going through others posts. I need a range (say AA3:AB3) to be copied, another file to be opened (we can call it Data.xls) and the range pasted into the next blank row and the file closed. etc. I'm having issues with the "next blank row" part of it. What's the easiest way to achieve this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to stop formulas from incrementing when you copy and paste? | Excel Worksheet Functions | |||
| Select, find in another book, copy, return and paste | Excel Discussion (Misc queries) | |||
| Copy cells from one worksheet and paste to incrementing sheets? | Excel Discussion (Misc queries) | |||
| copy and paste to different work book | Excel Programming | |||
| Select Range every 20 rows copy & paste special | Excel Programming | |||
Linear Mode
