Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Workbooks...
Hello MS Excel Community.
Here's the deal...I'm trying to find a way to update cells across four workbooks. All of the workbooks are formatted exactly the same with the exception of the filenames. I want to be able to open all four workbooks, some how highlight the cell where I want to make the change, make the change once, and have the change reflect in all of the workbooks - similar to making changes on multiple worksheets within one worbook. Any suggestions would be welcome. Markster |
#2
|
|||
|
|||
Hi
you can link three of your 4 workbooks/sheets to a master document -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello MS Excel Community. Here's the deal...I'm trying to find a way to update cells across four workbooks. All of the workbooks are formatted exactly the same with the exception of the filenames. I want to be able to open all four workbooks, some how highlight the cell where I want to make the change, make the change once, and have the change reflect in all of the workbooks - similar to making changes on multiple worksheets within one worbook. Any suggestions would be welcome. Markster |
#3
|
|||
|
|||
Hello Frank.
Thank you. I should have mentioned in my original e-mail that I am not interested in linking or consolidating - to much effort. My thinking is that if you can select , say, 20 worksheeets within one workbook, make a change to one cell, and have the change made to that cell in all of the remaining 19 worksheets, that you should be able to do the same with workbooks. I'm convinced that the gurus at MS had to contemplate such a scenario, I just can't seem to figure out how. Mark :) "Frank Kabel" wrote: Hi you can link three of your 4 workbooks/sheets to a master document -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello MS Excel Community. Here's the deal...I'm trying to find a way to update cells across four workbooks. All of the workbooks are formatted exactly the same with the exception of the filenames. I want to be able to open all four workbooks, some how highlight the cell where I want to make the change, make the change once, and have the change reflect in all of the workbooks - similar to making changes on multiple worksheets within one worbook. Any suggestions would be welcome. Markster |
#4
|
|||
|
|||
Hi
now you're talking about sheets within ONE single workbook. To achieve this try: - select / group all the sheets first (hold down the CTRL key while selecting them) - enter your value in a cell -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello Frank. Thank you. I should have mentioned in my original e-mail that I am not interested in linking or consolidating - to much effort. My thinking is that if you can select , say, 20 worksheeets within one workbook, make a change to one cell, and have the change made to that cell in all of the remaining 19 worksheets, that you should be able to do the same with workbooks. I'm convinced that the gurus at MS had to contemplate such a scenario, I just can't seem to figure out how. Mark :) "Frank Kabel" wrote: Hi you can link three of your 4 workbooks/sheets to a master document -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello MS Excel Community. Here's the deal...I'm trying to find a way to update cells across four workbooks. All of the workbooks are formatted exactly the same with the exception of the filenames. I want to be able to open all four workbooks, some how highlight the cell where I want to make the change, make the change once, and have the change reflect in all of the workbooks - similar to making changes on multiple worksheets within one worbook. Any suggestions would be welcome. Markster |
#5
|
|||
|
|||
Frank, I only used the worksheet deal as an example. I know how to make
chnages to several worksheets at one time, challenge is how do you accomplish when you are dealing with four workbooks, all with the same format and same-named worksheets. Please read my post carefully. Thnak you. Markster ------------ "Frank Kabel" wrote: Hi now you're talking about sheets within ONE single workbook. To achieve this try: - select / group all the sheets first (hold down the CTRL key while selecting them) - enter your value in a cell -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello Frank. Thank you. I should have mentioned in my original e-mail that I am not interested in linking or consolidating - to much effort. My thinking is that if you can select , say, 20 worksheeets within one workbook, make a change to one cell, and have the change made to that cell in all of the remaining 19 worksheets, that you should be able to do the same with workbooks. I'm convinced that the gurus at MS had to contemplate such a scenario, I just can't seem to figure out how. Mark :) "Frank Kabel" wrote: Hi you can link three of your 4 workbooks/sheets to a master document -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello MS Excel Community. Here's the deal...I'm trying to find a way to update cells across four workbooks. All of the workbooks are formatted exactly the same with the exception of the filenames. I want to be able to open all four workbooks, some how highlight the cell where I want to make the change, make the change once, and have the change reflect in all of the workbooks - similar to making changes on multiple worksheets within one worbook. Any suggestions would be welcome. Markster |
#6
|
|||
|
|||
Hi
as stated: For multiple workBOOKS not possible / supported in Excel. -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Frank, I only used the worksheet deal as an example. I know how to make chnages to several worksheets at one time, challenge is how do you accomplish when you are dealing with four workbooks, all with the same format and same-named worksheets. Please read my post carefully. Thnak you. Markster ------------ "Frank Kabel" wrote: Hi now you're talking about sheets within ONE single workbook. To achieve this try: - select / group all the sheets first (hold down the CTRL key while selecting them) - enter your value in a cell -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello Frank. Thank you. I should have mentioned in my original e-mail that I am not interested in linking or consolidating - to much effort. My thinking is that if you can select , say, 20 worksheeets within one workbook, make a change to one cell, and have the change made to that cell in all of the remaining 19 worksheets, that you should be able to do the same with workbooks. I'm convinced that the gurus at MS had to contemplate such a scenario, I just can't seem to figure out how. Mark :) "Frank Kabel" wrote: Hi you can link three of your 4 workbooks/sheets to a master document -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello MS Excel Community. Here's the deal...I'm trying to find a way to update cells across four workbooks. All of the workbooks are formatted exactly the same with the exception of the filenames. I want to be able to open all four workbooks, some how highlight the cell where I want to make the change, make the change once, and have the change reflect in all of the workbooks - similar to making changes on multiple worksheets within one worbook. Any suggestions would be welcome. Markster |
#7
|
|||
|
|||
Are you 100% sure about that Frank?
Markster "Frank Kabel" wrote: Hi as stated: For multiple workBOOKS not possible / supported in Excel. -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Frank, I only used the worksheet deal as an example. I know how to make chnages to several worksheets at one time, challenge is how do you accomplish when you are dealing with four workbooks, all with the same format and same-named worksheets. Please read my post carefully. Thnak you. Markster ------------ "Frank Kabel" wrote: Hi now you're talking about sheets within ONE single workbook. To achieve this try: - select / group all the sheets first (hold down the CTRL key while selecting them) - enter your value in a cell -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello Frank. Thank you. I should have mentioned in my original e-mail that I am not interested in linking or consolidating - to much effort. My thinking is that if you can select , say, 20 worksheeets within one workbook, make a change to one cell, and have the change made to that cell in all of the remaining 19 worksheets, that you should be able to do the same with workbooks. I'm convinced that the gurus at MS had to contemplate such a scenario, I just can't seem to figure out how. Mark :) "Frank Kabel" wrote: Hi you can link three of your 4 workbooks/sheets to a master document -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello MS Excel Community. Here's the deal...I'm trying to find a way to update cells across four workbooks. All of the workbooks are formatted exactly the same with the exception of the filenames. I want to be able to open all four workbooks, some how highlight the cell where I want to make the change, make the change once, and have the change reflect in all of the workbooks - similar to making changes on multiple worksheets within one worbook. Any suggestions would be welcome. Markster |
#8
|
|||
|
|||
Yes :-)
-- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Are you 100% sure about that Frank? Markster "Frank Kabel" wrote: Hi as stated: For multiple workBOOKS not possible / supported in Excel. -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Frank, I only used the worksheet deal as an example. I know how to make chnages to several worksheets at one time, challenge is how do you accomplish when you are dealing with four workbooks, all with the same format and same-named worksheets. Please read my post carefully. Thnak you. Markster ------------ "Frank Kabel" wrote: Hi now you're talking about sheets within ONE single workbook. To achieve this try: - select / group all the sheets first (hold down the CTRL key while selecting them) - enter your value in a cell -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello Frank. Thank you. I should have mentioned in my original e-mail that I am not interested in linking or consolidating - to much effort. My thinking is that if you can select , say, 20 worksheeets within one workbook, make a change to one cell, and have the change made to that cell in all of the remaining 19 worksheets, that you should be able to do the same with workbooks. I'm convinced that the gurus at MS had to contemplate such a scenario, I just can't seem to figure out how. Mark :) "Frank Kabel" wrote: Hi you can link three of your 4 workbooks/sheets to a master document -- Regards Frank Kabel Frankfurt, Germany "Markster" schrieb im Newsbeitrag ... Hello MS Excel Community. Here's the deal...I'm trying to find a way to update cells across four workbooks. All of the workbooks are formatted exactly the same with the exception of the filenames. I want to be able to open all four workbooks, some how highlight the cell where I want to make the change, make the change once, and have the change reflect in all of the workbooks - similar to making changes on multiple worksheets within one worbook. Any suggestions would be welcome. Markster |
#9
|
|||
|
|||
Hi,
Yes IT IS possible but only with a macro. Send the workbooks, or sample workbooks and info on what type of change you want to make and how you want to make it. Please do not generalise about the info. I am not a clairvoyant. See my stuff at: http://www.geocities.com/excelmarksway regards Mark -----Original Message----- Hello MS Excel Community. Here's the deal...I'm trying to find a way to update cells across four workbooks. All of the workbooks are formatted exactly the same with the exception of the filenames. I want to be able to open all four workbooks, some how highlight the cell where I want to make the change, make the change once, and have the change reflect in all of the workbooks - similar to making changes on multiple worksheets within one worbook. Any suggestions would be welcome. Markster . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting multi workbooks to talk | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
References to open/hidden workbooks become hard-coded in formulas - 2003 | Excel Discussion (Misc queries) | |||
Summing Values from different workbooks | Excel Discussion (Misc queries) | |||
How do I extract cells from multiple workbooks | Excel Discussion (Misc queries) |