Forum Discussion
Automate to a master sheet Excel
Hey all, My manager wants me to create automation whereby data entered into individual sheets (or tabs) gets automatically exported to a separate master sheet (or account) without manual interfer...
NikolinoDE
I am getting Error 9 for Set master = ThisWorkbook.Sheets("NameoftheSheet")
how do I proceed??
Change NameoftheSheet to the actual name of the sheet you want to refer to.