If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 . |
Thread Tools | |
Display Modes | |
|
|