hi everyone,
In Visual Basic Editor, how do i code it so that i can create a new spreadsheet with the name 'chk' and having numbers behind it everytime i want a new spreadsheet.
like if i click a button, chk1 is created, then click again, chk2 is created and so on..
also, when the spreadsheet is created, there is a template there already.
How do i reference a cell in the new spreadsheet?
Like in the new spreadsheet, A1 should have the value of my first spreadsheet in F3.
Please help me.
In Visual Basic Editor, how do i code it so that i can create a new spreadsheet with the name 'chk' and having numbers behind it everytime i want a new spreadsheet.
like if i click a button, chk1 is created, then click again, chk2 is created and so on..
also, when the spreadsheet is created, there is a template there already.
How do i reference a cell in the new spreadsheet?
Like in the new spreadsheet, A1 should have the value of my first spreadsheet in F3.
Please help me.
