Need copy data from specific sheet/cell to another [Closed]

Ask a question azibuck 2Posts Monday November 6, 2017Registration date November 7, 2017 Last seen - Last answered on Nov 6, 2017 at 05:21 PM by Ambucias
I have a macro that successfully takes a value from one sheet, "Job", and copies another worksheet, "Entry", and names the sheet for the value in a cell in Job. Here's what Job looks like:

Here's my macro, where I take the value in cell A14 and create a new sheet named 8, then the value in A15 to created a new sheet named 40, etc.

Sub CreateSheetsFromAList()
Dim MyCell As Range, MyRange As Range

Set MyRange = Sheets("Job").Range("A14")
Set MyRange = Range(MyRange, MyRange.End(xlDown))

For Each MyCell In MyRange
Sheets("Entry").Copy After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = MyCell.Value
Next MyCell
End Sub

The sheet entry has some info and a cell where I SUM some values. On each sheet (in this case 8, 40, and 99), the SUM is in cell A2. So I want to report that value back to the Job sheet, in the proper spot. So in cell B14, I want to pull the value from cell A2 in sheet 8, in cell B15, the value from A2 in sheet 15, and in cell B16, the value from A2 in sheet 99.

The chapter number will always vary, so I can't just hard-code in those number. I need to be able to read the value in Column A of Job and find the sheet named with that value. Can anyone help with that?
plus moins

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. Therefore, when asking for assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for help. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will increase your chances of getting the help you need.

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.


Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!