Hi Guys,
If anyone knows of a good online example or has their own example they'd be willing to share, I'd really appreciate it. Here's what I'm looking to do:
I routinely compare businesses for feasibility studies. Some studies have 4 comps, some studies have as many as 7-8. What would make my life easier is having a template that can add another comp, and all the summarized data from the new comp sheet with the click of a button.
I think copying a worksheet should be easy enough with some basic vba code. Adding the data from the additional comp to the summary sheet is where the problem lies.
First the data isn't disorganized, but there are multiple tables that make adding a row here or there difficult. What I mean is I have one information table that's only 3 columns wide, and another 5 column table immediately to the right of it to save space. If you add a row in one, it adds a row to the other table which would screw it up. So I'm guessing step 1 is to reorganize the summary sheet so I can insert additional rows without affecting multiple summary data tables?
Secondly, the tables are a mix of summary tables or tables that need rows added. In other words, one table averages the sales of all businesses - so the data from the add'l sheets would just have to be added to the calculation rather than adding add'l rows. Short of using IF-Then statements for the calculations to check if a value exists on comp5 - comp8, is there a better way to include the sheets in the calculations?
Maybe I'm looking at all this in the wrong fashion? Perhaps the easiest thing to do would just be to build an 8 comp spreadsheet, and then create a macro that removes 1, 2, 3 or 4 of the comps?
What do you guys recommend? Any tips/help are appreciated! Thanks!
If anyone knows of a good online example or has their own example they'd be willing to share, I'd really appreciate it. Here's what I'm looking to do:
I routinely compare businesses for feasibility studies. Some studies have 4 comps, some studies have as many as 7-8. What would make my life easier is having a template that can add another comp, and all the summarized data from the new comp sheet with the click of a button.
I think copying a worksheet should be easy enough with some basic vba code. Adding the data from the additional comp to the summary sheet is where the problem lies.
First the data isn't disorganized, but there are multiple tables that make adding a row here or there difficult. What I mean is I have one information table that's only 3 columns wide, and another 5 column table immediately to the right of it to save space. If you add a row in one, it adds a row to the other table which would screw it up. So I'm guessing step 1 is to reorganize the summary sheet so I can insert additional rows without affecting multiple summary data tables?
Secondly, the tables are a mix of summary tables or tables that need rows added. In other words, one table averages the sales of all businesses - so the data from the add'l sheets would just have to be added to the calculation rather than adding add'l rows. Short of using IF-Then statements for the calculations to check if a value exists on comp5 - comp8, is there a better way to include the sheets in the calculations?
Maybe I'm looking at all this in the wrong fashion? Perhaps the easiest thing to do would just be to build an 8 comp spreadsheet, and then create a macro that removes 1, 2, 3 or 4 of the comps?
What do you guys recommend? Any tips/help are appreciated! Thanks!
