Newbie. Trying to copy same workbook sheet data to another sheet.

zerrg12

New Member
Joined
Mar 10, 2021
Messages
2
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Hello.
What i am trying to do is. I have 40 sheets in one Workbook with specific names and each specific text in N3:N3842. Example of sheet name is "Trigger A1"
I am trying to make a front page sheet (Called "Complete"). Where Cell C7:C3846 fills with data from specific sheet name i put in Cell A2.
End game i want Sheet "Trigger A1" N3:N3842 to match C7:C3846 when i type in "Trigger A1" in cell A2.
I also would like if i change the name in cell A2 to different name like "Trigger A2" than it would take the data from that sheet and populate it in same columns and rows.
Forgive me. Tried to explain the best i can. All sheets are the same in size.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

metfast

New Member
Joined
Aug 26, 2017
Messages
18
Hi Mate have a look at this it worked for me

Regards Ge Perth Western Australia (GMT + 8hrs)
 

zerrg12

New Member
Joined
Mar 10, 2021
Messages
2
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Hi Mate have a look at this it worked for me

Regards Ge Perth Western Australia (GMT + 8hrs)
Hello metfast.
Even though your suggestion was in the right direction. Used it for my other sheets so thank you very much.
I ended up using =VLOOKUP(B7,INDIRECT(""&$A$2&"!C3:N3842"),12,0)
It worked the best for my application. Where B7 is where i populated my data in my master sheet and ""&$A&2&" was my sheets name pull down cell in the master sheet.
I was able to create lookup word in my master sheet than have it be searched at that sheet !C3:N3842 than have column 12 populate and dump data in my cell.
 

Forum statistics

Threads
1,137,125
Messages
5,679,760
Members
419,855
Latest member
Eddier32

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