Autofilling multiple sheets with values on a control sheet

[Dallas1000]

Good day,

I have a workbook with a control sheet of a thousand plus different names ranging from Cells B4:B1982, I have already created a thousand plus worksheets with templates now I want the names in the control sheet to autofill in Cell A3 of every worksheet.

PS the worksheets have not yet been named

Could you please assist?

[The_Greg]

Hello, do you mean that first worksheet after control sheet would have name from cell B4 and next sheet would have name from cell B5 from control sheet?

[ARowbot]

You've not really given us enough details but see if this works...If it doesn't then we need to know the current structure of the workbook and sheets.

Please Login or Register  to view this content.

[ARowbot]

Duplicate Post.

[Dallas1000]

great it worked thank you ARowbot,

thank The_Greg you were on the right there.

[Dallas1000]

I had another question,

Im only posting ont he same thread because it is the same workbook.

I have column a representing the 2000 names column B the descriptions and in Columc C I want to create hyperlinks to the repective 2000 sheets created.

every sheet is named after the name in column A and every sheet contains the product description in cell A2.

I want to hyperlink each line on the main control sheet to the corresponding worksheet.

Please assist.

[ARowbot]

Please Login or Register  to view this content.

[Dallas1000]

Thank you much appreciated.

If you could recommend a coarse to do basic traingin of excel programming,VBA, macros which would you?

[Dallas1000]

I would like to return the value of a set cell (B5)over multiple worksheets to the "main list" in column D in the same row as the matching Name (the name can be found in column A on the main list and on the worksheet cell(A2)

Would you be able to assist?

I tried to search for similar code but cant find something that matches my needs...

[ARowbot]

Thank you much appreciated.

If you could recommend a coarse to do basic traingin of excel programming,VBA, macros which would you?

I Personally used the following website alongside this forum and just trying to help others, to learn, myself. I am still learning and google is always your friend!

http://www.excel-easy.com/vba.html

It is getting difficult to help you without you uploading a minimalist and anonymous sample spreadsheet.

[Dallas1000]

Please find attached a sheet

basically in the "Main tracking" sheet under column D D4 should link to the same value of worksheet"19860010"'s cell B5
and so D5 should do it for the next sheet and so on and so on for all 1982 cells

thank you again

[ARowbot]

I am not willing to try and download that...Not only because its a zip folder but because of the name of the folder aswell!

[Dallas1000]

OK how do we go about this now?

I had to zip the file as it was 3mb...

[ARowbot]

Reduce the spreadsheet to be a sample only. It does not need to have all 2000 Sheets on for example. The template should also not contain any private or sensitive information.

[Dallas1000]

Good day

Please find attached the slim version

Thank you

[Dallas1000]

apologies for the waste of time

But it seems that I have gotten a way to make it work.