Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy 1 Sheet to Another
I posted something like this before, but maybe I wasn't clear in my
explanation. Let's say I have 2 workbooks (A and B) and workbook A is in directory X and workbook B is in directory Y. Sheet 1 of Workbook A has data in cells A1:F1 and an unlimited number of records. Sheet 1 of Workbook B has the same data that's on sheet 1 of Workbook A in it's cells A1:F1 (basically duplicate info) but sheet 1 of Workbook B also has other data in cells G1:K1. When a new record is added or if any of the cells gets updated in sheet 1 of Workbook A, I would like to copy all of sheet 1 of Workbook A (cells A1:F1) over into sheet 1 of Workbook B in its cell A1:F1 since both sheets have the exact same data in their A1:F1 range. But since sheet 1 of Workbook B has different data in its G1:K1 cells, I want to leave that alone in the copy operation. Can someone please help me on this. I'm new to these features of Excel and so I am somewhat lost. Thank you, |
#2
|
|||
|
|||
It sounds like you could just open both Workbooks, and instead of trying to
copy over the entire Sheet from one Book to another, (which of course would overwrite the G1:K1 range) , only copy over columns A:F.........this would not disturb the G:K range at all.......... Vaya con Dios, Chuck, CABGx3 "Dar" wrote in message ... I posted something like this before, but maybe I wasn't clear in my explanation. Let's say I have 2 workbooks (A and B) and workbook A is in directory X and workbook B is in directory Y. Sheet 1 of Workbook A has data in cells A1:F1 and an unlimited number of records. Sheet 1 of Workbook B has the same data that's on sheet 1 of Workbook A in it's cells A1:F1 (basically duplicate info) but sheet 1 of Workbook B also has other data in cells G1:K1. When a new record is added or if any of the cells gets updated in sheet 1 of Workbook A, I would like to copy all of sheet 1 of Workbook A (cells A1:F1) over into sheet 1 of Workbook B in its cell A1:F1 since both sheets have the exact same data in their A1:F1 range. But since sheet 1 of Workbook B has different data in its G1:K1 cells, I want to leave that alone in the copy operation. Can someone please help me on this. I'm new to these features of Excel and so I am somewhat lost. Thank you, |
#3
|
|||
|
|||
That's exactly what I want to do. I want to copy A:F range from sheet 1 of
Workbook A over into A:F range of sheet 1 of Workbook B. How can I do this? "Dar" wrote: I posted something like this before, but maybe I wasn't clear in my explanation. Let's say I have 2 workbooks (A and B) and workbook A is in directory X and workbook B is in directory Y. Sheet 1 of Workbook A has data in cells A1:F1 and an unlimited number of records. Sheet 1 of Workbook B has the same data that's on sheet 1 of Workbook A in it's cells A1:F1 (basically duplicate info) but sheet 1 of Workbook B also has other data in cells G1:K1. When a new record is added or if any of the cells gets updated in sheet 1 of Workbook A, I would like to copy all of sheet 1 of Workbook A (cells A1:F1) over into sheet 1 of Workbook B in its cell A1:F1 since both sheets have the exact same data in their A1:F1 range. But since sheet 1 of Workbook B has different data in its G1:K1 cells, I want to leave that alone in the copy operation. Can someone please help me on this. I'm new to these features of Excel and so I am somewhat lost. Thank you, |
#4
|
|||
|
|||
First, save both Workbooks and use a copy for this exercize...........
Then, open both Workbooks at the same time.......... Then click on the Window selection in the upper tool bar, and select the name of the Workbook you wish to copy FROM, this will activate it........ Then highlight columns A thru F by left-clicking on the A heading and holding it down and dragging it over to the F heading Then, right-click in that area and choose COPY from the dropdown Click on Window selection in the upper tool bar again, and choose the other Workbook, the one you wish to copy TO. Right-click on A column, and select Paste from the dropdown....... Vaya con Dios, Chuck, CABGx3 "Dar" wrote in message ... That's exactly what I want to do. I want to copy A:F range from sheet 1 of Workbook A over into A:F range of sheet 1 of Workbook B. How can I do this? "Dar" wrote: I posted something like this before, but maybe I wasn't clear in my explanation. Let's say I have 2 workbooks (A and B) and workbook A is in directory X and workbook B is in directory Y. Sheet 1 of Workbook A has data in cells A1:F1 and an unlimited number of records. Sheet 1 of Workbook B has the same data that's on sheet 1 of Workbook A in it's cells A1:F1 (basically duplicate info) but sheet 1 of Workbook B also has other data in cells G1:K1. When a new record is added or if any of the cells gets updated in sheet 1 of Workbook A, I would like to copy all of sheet 1 of Workbook A (cells A1:F1) over into sheet 1 of Workbook B in its cell A1:F1 since both sheets have the exact same data in their A1:F1 range. But since sheet 1 of Workbook B has different data in its G1:K1 cells, I want to leave that alone in the copy operation. Can someone please help me on this. I'm new to these features of Excel and so I am somewhat lost. Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move or copy more then one sheet at a time | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Find a non-blank cell and bring back text a in same row | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
How Can I copy a sheet that has hidden rows without copying the h. | Excel Worksheet Functions |