I am working on some forms for a button in a spreadsheet.
two Button Commands in VB excel.
Here are my notes as to what I think will be needed to get the job done:
Click NY1TR
Send Data from 'Perfect 'Analyzer' ("B2:C273") to 'Tables' ("AV1")
Send Data from 'Analyzer' ("B2:C273") to 'Tables' ("AV2")
Click NY1PI
Send Data from 'Analyzer' ("B2:C273") to 'Tables' ("AV175")
Send Data from 'Analyzer' ("B2:C273") to 'Tables' ("AV176")
My analyzer sheet has two buttons that are going to send data to another sheet.
I am thinking that I can 'copy' and 'paste'.
This button will reside in the worksheet and will be clicked once data is imported.
My information flows into the analyzer spreadsheet, then to a table spreadsheet that aggregates all the data, then a spreadsheet for the graphs.