How Do I Copy Cells From One Sheet To Another

A

AshParr

Hey there guys,

I have a problem i would like some help with,

I have Two Sheets:
The first sheet i have is Called "Real Time"
I then have a second sheet called "History"

The Real Time Sheet has data wrote into it constantly, from a outside
source.

I would like to copy cell A1 from the "Real Time" sheet and paste that
into the next empty cell in the "History" Sheet in Column A.

I would like to copy cell B1 from the "Real Time" sheet and paste that
into the next empty cell in the "History" Sheet in Column B.

I would like to copy cell C3 from the "Real Time" sheet and paste that
into the next empty cell in the "History" Sheet in Column C.

I am planing on copying these across after a set time, e.g 1 minute or
1 hour

======================================================================

Many Thanks In Advance,
Ash
 
G

Guest

Just as a word of caution when you create your workbook you can not have a
sheet called "history". Through an odd quirk of XL "history" is a reserved
word so you can not give a sheet that name (unless this is fixed in 2007).
 
A

AshParr

ok then, i have not tried this yet but will get to work on it
tomorrow! i will have to change the sheet name
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create if partial match then copy and paste data from one cell to another 1
Copy Data from Sheet 1 to Empty Cell in Sheet 2 2
Auto Copy Data from one worksheet to another 1
macro to copy columns from one sheet to another sheet 4
Somewhat complex code to copy data from one sheet to another 9
Finding, grouping, then copy/paste to new sheet 15
Reference Separate Sheet for Formula 2
enter key behavior - by sheet 4

Top