VBA, copy and paste, paste tab to look at a cell value

Hey guys,

I have 53 tabs, week 1-52 and an INPUT tab,
I want to create a macro that copies data from INPUT TAB and pastes into the tab name which = cell A1 on INPUT TAB.


I believe I need INPUT cell A1 = string.
Then have my sheets(" CELL A1 ").paste,

I think!!! probably not...

Sounds like you have an understanding of VB code, so I'm just gonna go ahead and throw the code at you. I've kept everything very simple so I think you can pick your way through it and make it work for you. If not, let me know and we'll move forward from there!

Please Login or Register  to view this content.

Thanks for rapid response,

I know a little bit about VB, but don't know how to code with it

"Cells(1, 1).Value

Worksheets(sheetname).Cells(1, 1) = Cells(1, 3)"

I don't understand the 1, 1 or 1, 3, if it makes anything less painful the cell I want the .paste(tabname) to look at is "Input Sheet" F43.

BTW i love your signature, made me LOL

The "Cells" method of reference uses a (row number, column number)
So cells(1, 1).value is cell A1 of the activesheet, since no other sheet is specified.
Worksheets(sheetname).cells(1, 1) = cells(1, 3) means (In the example workbook I posted):
Worksheet Sheet2 cell A1 = cell C3 of the first page. (The active one with the button on it)
Does that sorta help?

p.s.
Thanks, I get a lot of compliments on the signature. I've had it up for quite a while but I still think it's hillarious.

mew!