Name Macro

[mahen]

Required a macro to copy Names from Summary tab to Rest of the appropriate tabs in c3 (highlighted in yellow). Physically copied in Name1 tab.

Thanks.
Mahen

 

[Brianwarnock]

Interesting request, normally summary sheets get their information from the detail sheets, where does the information in the summary sheet come from?

Brian

 

[mahen]

Thanks Brian for looking into. Information in Summary sheet is copy from another file physically. Only column C information is need to copy into appropriate sheet in C3.

 

[Brianwarnock]

OK , assuming that the table and sheets are in the same order and the first name sheet is sheet 3 as per your example simple code as below should work.

Brian

Dim r As Long ' row index
Dim n As Long  ' sheet index
r = 3
n = 3
Do
Worksheets(n).Range("a5") = Worksheets("summary").Cells(r, 3)
r = r + 1
n = n + 1
Loop Until Worksheets("summary").Cells(r, 3) = ""

 

[mahen]

Thanks Brian. I am getting " Complier Error: Invalid outside prodecure". Not sure where you get sheet 3 from. Also not sure about why A5. Summary sheet contain a two table. Column B, name of the sheets and column C contain appropriate Names which should copy into the Name1 to Name4 in cell c3. Edit my file and re-send please.

thanks

 

[Brianwarnock]

Ok sheet3 and A5 where leftoversfrom a test, but esily corrected if you know VBA , but i'm guessing you don't given that ou got a compile error.

I've attached the workbook with the sub, to view right click the summary tab and click view code.

Brian

 

[mahen]

Brian,
Perfect. Working now. I did sub and end. But had that error.
Thanks you.
Mahen

 

[Brianwarnock]

Happy to have helped.

Brian