Copy same cell from multiple sheets into a range of cells in another sheet

anriley

New Member
Joined
Jul 7, 2022
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I am trying to copy data from cell IF10 in up to 31 sheets and input these data, in order, into a row on another sheet.

More details: cell IF10 in sheet "1" contains a single number (e.g., "3,400"). this number needs to be inputted into sheet "Daily Delivered" in cell C132.

Basically, I need to know if there is a way to take the same cell from multiple sheets and paste the data, horizontally, into a range of cells (C-AG) on a different sheet.
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
19,335
Office Version
  1. 2013
Platform
  1. Windows
You said:
More details: cell IF10 in sheet "1"
What exactly is the sheet name.
Is it "1"

Or what.
Why not use a name Like "Alpha" Or "Bravo"
See put the exact name in Quotes like I did

And you said "Copy same cell from multiple sheets"

What does that mean all sheets except for sheet name "1" or whatever.
And if not give names of all the sheets you want included.
And you said:
inputted into sheet "Daily Delivered" in cell C132.

So first into Range C132 then D132 then E132 and so on
If this, correct?
To help you I need specific details like this.
 

anriley

New Member
Joined
Jul 7, 2022
Messages
2
Office Version
  1. 365
Platform
  1. Windows
You said:
More details: cell IF10 in sheet "1"
What exactly is the sheet name.
Is it "1"

Or what.
Why not use a name Like "Alpha" Or "Bravo"
See put the exact name in Quotes like I did

And you said "Copy same cell from multiple sheets"

What does that mean all sheets except for sheet name "1" or whatever.
And if not give names of all the sheets you want included.
And you said:
inputted into sheet "Daily Delivered" in cell C132.

So first into Range C132 then D132 then E132 and so on
If this, correct?
To help you I need specific details like this.
I ended up just downloading the excel add-on "Kutools" and it solved my issue. Thank you anyways for your help.
 

Forum statistics

Threads
1,181,770
Messages
5,931,933
Members
436,809
Latest member
dtechhh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top