macro for: Cut and Paste into next available cell

[rhysyt]

Hey,

I need to be able to write the macro that can cut and paste some data from one spreadsheet into another new spreadsheet but so that it pastes data into the next available cell in row 3 of the new spreadsheet. I'm not very good at VB but i can read it and understand what the commands are doing so yeah any help would be greatly appreciated.

Cheers,

Rhys

 

[acw]

Rhys

Bit more detail.

What is the input sheet.
What is the output sheet.
How many cells will you be moving (ie just the current cell, or a selected range of cells).
What is the trigger for the move (button, cell entry....)
Is it really a cut and paste, or is it a copy (ie does the data remain on the source or is deleted).


Tony

 

[rhysyt]

Hey Tony,

i have the prices of some company stocks in one sheet that i download from the internet. I then format this sheet so it only shows me the company code, the date and the price next to it. I need to get the price data from this spreadsheet into another spreadsheet called SuperFundsGraphed.xls. each column in the superfundsgraphed spreadhsheet is a new date i.e 24/5/06, 25/5/06 etc. I want to be able to write the macro that takes the data from the sheet that i download from the internet for any particular day and then either finds that same date in superfundsgraphed.xls and puts the price underneath that date. This is a pretty convoluted explanation but yeah i dont know how else to explain it.

 

[agihcam]

download html maker to post your spread sheet on the board;

http://www.puremis.net/excel/downloads.shtml