| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do I Copy Cells From One Sheet To Another
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Do I Copy Cells From One Sheet To Another
Hi Ash
Start here http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ups.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Do I Copy Cells From One Sheet To Another
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). -- HTH... Jim Thomlinson " wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Do I Copy Cells From One Sheet To Another
Not possible in 2007 Jim
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jim Thomlinson" wrote in message ... 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). -- HTH... Jim Thomlinson " wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Do I Copy Cells From One Sheet To Another
Thanks... I had not tried it and I don't have 2007 here at work.
-- HTH... Jim Thomlinson "Ron de Bruin" wrote: Not possible in 2007 Jim -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jim Thomlinson" wrote in message ... 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). -- HTH... Jim Thomlinson " wrote: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Do I Copy Cells From One Sheet To Another
ok then, i have not tried this yet but will get to work on it
tomorrow! i will have to change the sheet name |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
| Copy sheet cells into differnt workbook/sheet, How? | Excel Discussion (Misc queries) | |||
| copy data of two cells from Sheet 2 into one cell in Sheet 1 | Excel Worksheet Functions | |||
| Copy sheet and clear cells on new sheet at sametime. | Excel Programming | |||
| Copy row sheet-sheet skipping unqualified cells | Excel Worksheet Functions | |||
Linear Mode
