ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Using multiple spreadsheet for different information (https://www.excelbanter.com/setting-up-configuration-excel/5038-using-multiple-spreadsheet-different-information.html)

Urgent

Using multiple spreadsheet for different information
 
I have a master spreadsheet that I would like to collect information from.
in the same file I will create another spreadsheet that I would like to
collect information from the master. How do I do this without using paste
link? There are several different columns from the master that I would like
to have totals show on the second spreadsheet. Did I explain this good
enough?

SgtYork


I'm not sure if this will fix your problem, but from the cell on your
totals page, try hitting the "=" sign and then click on the cell you
want to information from. If they're in the same doc that will keep
the file size down.



--
SgtYork
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1314930.html



All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com