Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Move replace instead of Move copy
I have 2 workbooks, and need to synchronise WorkSheet1
of one workbook with WorkSheet1 in another workbook. The Create a copy only lets me copy, not replace. So if I copy from Workbook1 to Workbook2 the copied sheet becomes Worksheet2 I want the Copy to replace the contents of Worksheet1 but there is no Copy Replace option between workbooks. Is there a simple way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Move replace instead of Move copy
Hi,
You can right click on sheet1 and delete it after the copy then double click on sheet2 and rename it. Alternatively you can put this formula in cell A1 of Book2 Sheet1 =IF([Book1]Sheet1!A1="","",[Book1]Sheet1!A1) Then click on the fill handle and drag it down as far as is needed, then with the whole column highlighted click on the fill handle again and drag it across as far as is needed. That way any entry made in Book1 will automatically go into Book2 provided both files are open. HTH Martin wrote in message ... I have 2 workbooks, and need to synchronise WorkSheet1 of one workbook with WorkSheet1 in another workbook. The Create a copy only lets me copy, not replace. So if I copy from Workbook1 to Workbook2 the copied sheet becomes Worksheet2 I want the Copy to replace the contents of Worksheet1 but there is no Copy Replace option between workbooks. Is there a simple way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Move replace instead of Move copy
Many thanks I'll give it a try.
I just want the Sheet Index number to stay the same, so the macros which refer to Sheet1 still work. The don't if the copy becomes Sheet2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move and Copy | New Users to Excel | |||
excel-how to get the spreadsheet to move as I move the scroll tab | Excel Discussion (Misc queries) | |||
Move or Copy | Excel Discussion (Misc queries) | |||
How do I stop making the spreadsht move when I move up/dwn/lt/rt? | Excel Worksheet Functions | |||
When I move scroll bar in excell the contents do not move with it | Excel Discussion (Misc queries) |