Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste in steps
Hey all,
How would I copy a certain amount of rows (customer data info) from a workbook to paste into a master database based on a cell which indicates the number of rows? For example, I have a worksheet with 15 rows of customer data. I just want to copy 4 rows - (this is based on a cell in A1 signifying I want only the first 4 rows copied.) Based on that, I'd run a macro which would copy only those 4 rows (starting from rows 3 to row 6) and paste them into a master database. The paste will happen at the next row from the end of the master database. Thanks for your help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
help w/ generic copy & paste/paste special routine | Excel Programming | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming |