DYLANATT1999
New Member
- Joined
- Aug 8, 2021
- Messages
- 8
- Office Version
- 2016
- Platform
- Windows
Excel Sheet
The above is an example spreadsheet.
To give context, I have data that exports from a database to an Excel spreadsheet. I want to be able to quickly calculate the information that is exported from the database and save the result.
For example on the attached, Sheet 1 contains the data. Sheet 1 contains the formula.
You can see the corresponding headings in B3:H3 in sheet 2 to sheet 1 C4:C9
I want to be able to enter the data into sheet 2 and then click run and it will run until the table last line is blank, then it will stop as I will add more lines to the table
In sheet 1 I also want to be able to recall the information from a select line in sheet 2, I have created a user form for this.
Sorry for all the requirements, any guidance would be appreciated - I am pretty new to VBA
The above is an example spreadsheet.
To give context, I have data that exports from a database to an Excel spreadsheet. I want to be able to quickly calculate the information that is exported from the database and save the result.
For example on the attached, Sheet 1 contains the data. Sheet 1 contains the formula.
You can see the corresponding headings in B3:H3 in sheet 2 to sheet 1 C4:C9
I want to be able to enter the data into sheet 2 and then click run and it will run until the table last line is blank, then it will stop as I will add more lines to the table
In sheet 1 I also want to be able to recall the information from a select line in sheet 2, I have created a user form for this.
Sorry for all the requirements, any guidance would be appreciated - I am pretty new to VBA
