VBA TO PULL DATA FROM ANOTHER WORKSHEET

[DYLANATT1999]

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

 

[DYLANATT1999]

Also on Vba that will pull information from another worksheet