A Macro that will cut and paste to specific cell

Tech-Archive recommends: Fix windows errors by optimizing your registry



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
.



Relevant Pages

  • Re: Question
    ... How about adding an appointment to your Outlook calendar, ... Then Excel doesn't have to ... Then run the macro. ... create an appointment at 8:00 on the date of each cell in B1:B10. ...
    (microsoft.public.excel.programming)
  • Update a Web Query and be able to change the WebAddress manually from a specific Cell
    ... I use an Excel Macro which updates stock prices from the internet by ... Have a cell in Excel where I manually enter GM or GOOG etc. ...
    (microsoft.public.excel.programming)
  • Re: COUNTIF question
    ... If you are using excel 2000 or newer you may have to change the macro ... They will read only the default colors of the cell and its ... 11 Dark Blue ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Appending record with VBA when surname is True(sic)
    ... the type of thing which is called a macro in Excel ... either with a macro or with a vba procedure, would be relatively simple, ... based on processing the data cell by cell, so I suppose data types are ...
    (microsoft.public.access.macros)
  • Re: VBA: For Count, when count changes from cell to cell
    ... with Excel 2000. ... reporting Macro being unavailable. ... Sub CalculateI3() ... means that you can refer to it in a cell just like a built-in Excel function. ...
    (microsoft.public.excel.misc)