# Excel - COLUMN Function Problem - Expert Solution

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
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
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
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
User 04/08/2017 - 07:02
?
Excelchat Expert 04/08/2017 - 07:03
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
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
Excelchat Expert 04/08/2017 - 07:07
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.