ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   A Macro that will cut and paste to specific cell (https://www.excelbanter.com/excel-discussion-misc-queries/19956-macro-will-cut-paste-specific-cell.html)

VBA12thRoundDraftPick

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

Mark

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
.



All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com