ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combining data from multiple worksheets and separate spreadsheets (https://www.excelbanter.com/excel-discussion-misc-queries/104289-combining-data-multiple-worksheets-separate-spreadsheets.html)

kfletchb

Combining data from multiple worksheets and separate spreadsheets
 
How do I take data from one worksheet and perform formulas with data on
another worksheet? How do I do this with separate spreadsheets? Mahalo.
Karen

raypayette

Combining data from multiple worksheets and separate spreadsheets
 

In the resulting worksheet insert an equal sign and select another
worksheet, it will provide a formula similar to:
=Sheet2!D4


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=570462



All times are GMT +1. The time now is 06:37 AM.

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