Question description:
This user has given permission to use the problem statement for this
blog.
I have a master sheet in my workbook with record ID's in one column that are named in reference to other sheets in the workbook. 429 in total. In a column in my master sheet, I would like to take a value from the same cell in each sheet in put it in its corresponding row record ID in the new column.
Solved by C. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
04/08/2017 - 06:49
Hello sir
Excelchat Expert
04/08/2017 - 06:49
How could I help you
User
04/08/2017 - 06:50
If you understand my problem, F5 is the cell I would like to take the value from
User
04/08/2017 - 06:51
I have added two sheets and the master as example
User
04/08/2017 - 06:51
I wanto fill column E in master without having to it manually or one by one
Excelchat Expert
04/08/2017 - 06:52
Ok What data should be in column E
User
04/08/2017 - 06:52
The value in F5 from sheets 1 and 2. They should correspond to their sheet name which is also record ID in master
Excelchat Expert
04/08/2017 - 06:55
What do you mean sir " correspond to their sheet name which is also record ID in master"
User
04/08/2017 - 06:55
I would eventually like to do this for all 459, which I have not added here
Excelchat Expert
04/08/2017 - 06:55
Please give an example
User
04/08/2017 - 06:55
The sheets are named 1, 2, etc..
Excelchat Expert
04/08/2017 - 06:55
Ok
Excelchat Expert
04/08/2017 - 06:56
In the sheet 1 Range F5 there is a data 12.1
User
04/08/2017 - 06:56
The number in Record ID column in master is supposed to reference the sheet
Excelchat Expert
04/08/2017 - 06:56
Where should it be post ?
User
04/08/2017 - 06:57
Its supposed to go in column E in master and match the row name, record ID, to the sheet
User
04/08/2017 - 06:57
So whatever value is in F5 for that sheet goes in the correct row in master
User
04/08/2017 - 06:58
I want to be able to automate this so I dont have to manually get each one from all 459
Excelchat Expert
04/08/2017 - 06:59
You mean hyperlink?
Excelchat Expert
04/08/2017 - 06:59
Sir ?
User
04/08/2017 - 06:59
Yes essentially hyper link all of them for each row in master
Excelchat Expert
04/08/2017 - 06:59
Sir It's a VBA session then
Excelchat Expert
04/08/2017 - 06:59
I could do
Excelchat Expert
04/08/2017 - 07:00
It's possible to make a hyper link for 50 sheets
Excelchat Expert
04/08/2017 - 07:00
But not for 459
Excelchat Expert
04/08/2017 - 07:00
It's unreal
Excelchat Expert
04/08/2017 - 07:01
It could be easily solved by VBA
User
04/08/2017 - 07:01
Ok so do I need to start a VBA session so I can get help writing a script?
Excelchat Expert
04/08/2017 - 07:02
Just please add to the "My question about' VBA
User
04/08/2017 - 07:02
?
Excelchat Expert
04/08/2017 - 07:03
[Uploaded an Excel file]
Excelchat Expert
04/08/2017 - 07:03
Sir could you please check this file Sheet 2
Excelchat Expert
04/08/2017 - 07:04
Range F5
Excelchat Expert
04/08/2017 - 07:04
Just Please re post your session as VBA Session
Excelchat Expert
04/08/2017 - 07:04
Could you wait for a minute
User
04/08/2017 - 07:04
Ok
Excelchat Expert
04/08/2017 - 07:07
https://docs.google.com/spreadsheets/d/1uptqmslQk6DHKnWGorB5dykYoMs0YcYpiSKn5_Tuqmw/edit#gid=0
Excelchat Expert
04/08/2017 - 07:07
Please go to this link
Excelchat Expert
04/08/2017 - 07:08
Please don’t forget to rate the session, thank you.
User
04/08/2017 - 07:08
Ok
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.