dweeballina
11-23-2010, 02:10 PM
I have a series of spreadsheets, driven off of one data sheet (variable number of rows) that I need to populate using specific formulas. I've attached a very simplified version of what I'm looking to do. I've had success with a single line creator, but this is for multiple lines of data, and I've had no luck even getting started what I need.
The worksheet "MAIN DATA" contains the data that drives most of my formulas on the next two sheets, and it will have varying numbers of rows.
The worksheet "FORMULA SHEET 1" contains the basic formula's that I'm working with. I need to replicate the formula in row 2 for each row on "MAIN DATA" and paste as values below (rows 3 to where ever it ends) on the same "FORMULA SHEET 1". Same holds true for "FORMULA SHEET 2.
The final sheet I'm using, "LOOKUP DATA", is just a basic data table, where I hold some lookup data that fills in extra columns that I have to populate.
I'd ultimately like to have a macro that works to create all necessary rows on both "FORMULA SHEET"s.
Can anyone help, or maybe point me towards a thread that can?
The worksheet "MAIN DATA" contains the data that drives most of my formulas on the next two sheets, and it will have varying numbers of rows.
The worksheet "FORMULA SHEET 1" contains the basic formula's that I'm working with. I need to replicate the formula in row 2 for each row on "MAIN DATA" and paste as values below (rows 3 to where ever it ends) on the same "FORMULA SHEET 1". Same holds true for "FORMULA SHEET 2.
The final sheet I'm using, "LOOKUP DATA", is just a basic data table, where I hold some lookup data that fills in extra columns that I have to populate.
I'd ultimately like to have a macro that works to create all necessary rows on both "FORMULA SHEET"s.
Can anyone help, or maybe point me towards a thread that can?