Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit 2 workbooks at same time
I want to edit 2 workbooks at the same time. They have same info except one
includes phone numbers and one doesn't. THey are lists of officers in different divisions which change each month. I want to make the changes to both workbooks at the same time so I don't have to do it twice. I feel this should be easy. For example when you edit 2 worksheets you can press shift and click on the tab of the worksheet you want to edit. I want to edit 2 workbooks at the same time moving the names of the officers around. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit 2 workbooks at same time
I don't think you'll find an easy way to do this.
You could move the worksheets into a common workbook, do the grouping, then the changes and move one of the worksheets back into the original workbook. But it sounds like your changes would be too complex for this to work. Personally, I would do my best to put all the information I needed into a single worksheet. Then I may be able to enter a unique value (like name or SSN or employee id) in a cell and use a bunch of =vlookup()'s to retrieve the values I need for that workbook. Pat Hughes wrote: I want to edit 2 workbooks at the same time. They have same info except one includes phone numbers and one doesn't. THey are lists of officers in different divisions which change each month. I want to make the changes to both workbooks at the same time so I don't have to do it twice. I feel this should be easy. For example when you edit 2 worksheets you can press shift and click on the tab of the worksheet you want to edit. I want to edit 2 workbooks at the same time moving the names of the officers around. Any ideas? Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit 2 workbooks at same time
How about using link.provided that you have an exact content. eg. in Workbook
B cell A1, you press "=" then point to WB A cell A1. You will get Absolute link. Now you can remove the absolute sign ("$") from the cell A1 in Workbook B. You can now copy this to other cell. Will it help? You have to remove the mergecell fotr the copy to work though. Have a good weekend "Pat Hughes" wrote: I want to edit 2 workbooks at the same time. They have same info except one includes phone numbers and one doesn't. THey are lists of officers in different divisions which change each month. I want to make the changes to both workbooks at the same time so I don't have to do it twice. I feel this should be easy. For example when you edit 2 worksheets you can press shift and click on the tab of the worksheet you want to edit. I want to edit 2 workbooks at the same time moving the names of the officers around. Any ideas? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit 2 workbooks at same time
I would think the best way is to reference the cells in one sheet from the
other sheet like so: in cell a1 of sheet 2 enter: =Sheet1!A1 if this was in cell a1 on sheet2, then it would always have the same value as cell a1 on sheet1. Do for as many cells as required, via copy and paste. Is this the sort of thing you are looking for? -- future_vba_expert "Pat Hughes" wrote: I want to edit 2 workbooks at the same time. They have same info except one includes phone numbers and one doesn't. THey are lists of officers in different divisions which change each month. I want to make the changes to both workbooks at the same time so I don't have to do it twice. I feel this should be easy. For example when you edit 2 worksheets you can press shift and click on the tab of the worksheet you want to edit. I want to edit 2 workbooks at the same time moving the names of the officers around. Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i Edit many Cells at a time. | Excel Discussion (Misc queries) | |||
Multiple users edit same spreadsheet at same time? | Excel Discussion (Misc queries) | |||
edit more than one Hyperlink at a time | Excel Worksheet Functions | |||
Edit Macro 1st time use | Excel Discussion (Misc queries) | |||
unable to edit any of my workbooks | Excel Worksheet Functions |