macro for: Cut and Paste into next available cell

rhysyt

New Member
Joined
Oct 5, 2006
Messages
2
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
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
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

New Member
Joined
Oct 5, 2006
Messages
2
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.
 

Forum statistics

Threads
1,136,878
Messages
5,678,315
Members
419,754
Latest member
LordEddard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top