Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell auto-updating
I have a multitude of excel files which I need to pull data from into one
master sheet. The problem is the data in those cells may change from an individual sheet. Is there anyway to change the cell of the individual sheet and see those changes on the master sheet I am creating? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell auto-updating
How about type = in the master sheet
navigate to the source sheet and click on that cell Enter if you need to add the different values in these source cells, simply type + and repeat 2nd step of the above -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "TechGuy" wrote: I have a multitude of excel files which I need to pull data from into one master sheet. The problem is the data in those cells may change from an individual sheet. Is there anyway to change the cell of the individual sheet and see those changes on the master sheet I am creating? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell auto-updating
I am needing it to populate from the source sheets but also update on the
master when the source sheet gets changed. Thanks for the quick reply. "Francis" wrote: How about type = in the master sheet navigate to the source sheet and click on that cell Enter if you need to add the different values in these source cells, simply type + and repeat 2nd step of the above -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "TechGuy" wrote: I have a multitude of excel files which I need to pull data from into one master sheet. The problem is the data in those cells may change from an individual sheet. Is there anyway to change the cell of the individual sheet and see those changes on the master sheet I am creating? Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell auto-updating
Whoa! All those '=' characters will make your workbook bloat up to a
something massive, and probable uncontrollable. Try this instead: http://www.rondebruin.nl/copy2.htm If you are new to VBA, look he http://www.anthony-vba.kefra.com/vba/vbabasic1.htm Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "TechGuy" wrote: I am needing it to populate from the source sheets but also update on the master when the source sheet gets changed. Thanks for the quick reply. "Francis" wrote: How about type = in the master sheet navigate to the source sheet and click on that cell Enter if you need to add the different values in these source cells, simply type + and repeat 2nd step of the above -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "TechGuy" wrote: I have a multitude of excel files which I need to pull data from into one master sheet. The problem is the data in those cells may change from an individual sheet. Is there anyway to change the cell of the individual sheet and see those changes on the master sheet I am creating? Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell auto-updating
GREAT! I got it working. Thank you both for your help.
"ryguy7272" wrote: Whoa! All those '=' characters will make your workbook bloat up to a something massive, and probable uncontrollable. Try this instead: http://www.rondebruin.nl/copy2.htm If you are new to VBA, look he http://www.anthony-vba.kefra.com/vba/vbabasic1.htm Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "TechGuy" wrote: I am needing it to populate from the source sheets but also update on the master when the source sheet gets changed. Thanks for the quick reply. "Francis" wrote: How about type = in the master sheet navigate to the source sheet and click on that cell Enter if you need to add the different values in these source cells, simply type + and repeat 2nd step of the above -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "TechGuy" wrote: I have a multitude of excel files which I need to pull data from into one master sheet. The problem is the data in those cells may change from an individual sheet. Is there anyway to change the cell of the individual sheet and see those changes on the master sheet I am creating? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating an Auto-Filter depending on cell value | Excel Worksheet Functions | |||
Auto Updating | Excel Worksheet Functions | |||
Cell formula not updating, auto calc on, over 100 sheets | Excel Discussion (Misc queries) | |||
Cell showing the time auto updating | Excel Discussion (Misc queries) | |||
How can I use the NOW function and keep it from auto updating? | Excel Worksheet Functions |