ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   working with multiple worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/53502-working-multiple-worksheets.html)

Shaun

working with multiple worksheets
 
I would like to collect data from one specific cell (cell E3) in 90
worksheets and have this data placed in one column from 1-90 on one single
worksheet. Is there a way to do this without doing it one by one?

Biff

working with multiple worksheets
 
Hi!

Are you using the default sheet names? (probably not, huh?)

If there is some common sequence in the sheet names then a formula could
probably be crafted to do this.

Biff

"Shaun" wrote in message
...
I would like to collect data from one specific cell (cell E3) in 90
worksheets and have this data placed in one column from 1-90 on one single
worksheet. Is there a way to do this without doing it one by one?





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

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