Home |
Search |
Today's Posts |
#1
|
|||
|
|||
A Macro that will cut and paste to specific cell
I import tables from web into excel. These tables vary in size. Therefore one
day the first table may go from A:7 to P:20 then the second table starts at A:22 and ends at P:40 and so on. Then the next day the first table may be A:7 to P:12 and the second A:14 to P:33. I need each table to have the same starting point each day. I have been cutting and pasting each individule table to achieve this. Is there a macro that can do this or a macro at the very least if highlight the table will then cut and paste for me to a specific cell. Thank you for any help you can give |
#2
|
|||
|
|||
Hi,
can you send me the worksheet so I can see the layout of your tables. Also tell me what you want done with the info. See my credentials and XL utilities at http://www.geocities.com/excelmarksway - Mark -----Original Message----- I import tables from web into excel. These tables vary in size. Therefore one day the first table may go from A:7 to P:20 then the second table starts at A:22 and ends at P:40 and so on. Then the next day the first table may be A:7 to P:12 and the second A:14 to P:33. I need each table to have the same starting point each day. I have been cutting and pasting each individule table to achieve this. Is there a macro that can do this or a macro at the very least if highlight the table will then cut and paste for me to a specific cell. Thank you for any help you can give . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|