how to copy data from same cell from multiple worksheets within same workbook to separate cells with worksheet name | General Excel Questions & Answers

how to copy data from same cell from multiple worksheets within same workbook to separate cells with worksheet name

Kaye Lowes

Member

Members

Forum Posts: 4

Member Since:
October 22, 2015

Offline

June 17, 2017 - 12:43 am

Just wondering if you could provide me with any assistance in how I can copy data from the same cell on different worksheets within the same workbook to a separate cell on the new worksheet to achieve the example below

Sheet 1 500

Sheet 2 700

Sheet 3 800

I have 136 worksheets that I need to be able to list the results without having to select each worksheet separately to link the data. Can this be done?

Regards

Kaye Lowes

See Answer

SunnyKow

Malaysia

Member

Members

Dashboards

Forum Posts: 704

Member Since:
June 25, 2016

Offline

June 17, 2017 - 12:40 pm

Hi Kaye

Are you trying to summarize the values from multiple sheets based on the sheet's name in a cell?

Maybe you can see if this is what you wanted.

Sunny

Kaye Lowes

Member

Members

Forum Posts: 4

Member Since:
October 22, 2015

Offline

June 20, 2017 - 10:04 am

Hi Sunny Thank you I will give that a try.

I have tried you suggestion and got the result below. I am trying to get the value from C7 of each worksheet into the Result worksheet. I used a macro to create the list of sheet names. Is there something else I need to do?