Hi, I am new to VBA and trying to create a form for a gas station. The form is made so a user can enter sales information and it will calculate month to date totals as pages are added through a new day button at the top. The button should create a new sheet that is named as the next day. The...
can you please help me with replacing the worksheet data below to point to the current workbook and worksheet?
It won't only be me running the code.
"WorksheetConnection_Test.xlsm!Table1", "", _...
i was wondering if this code
ActiveSheet.Name = "Pending"
ActiveSheet.Name = "Closed"