Problems with an Excel Compiler - long

bashey72

New Member
Joined
Jan 20, 2009
Messages
3
Hello Everyone, I have a problem where I really need a solution for. I have been working manually two days straight on this at work and I am getting so frustrated. I have very little knowledge of how to fix macros.

We have an excel capital investment proposal compiler ( Excel 97-2003) that is supposed to pull data in from different project sheets where cost and data vary across sites. I have used this for several projects and it has worked.

The problem I am now having is that, this new project will start in different years. 2014, 2015,2016 and 2017. I have a file for all of thses that I will be attaching. I go to my Compiler file and pull in all this information. See Sheets ( Building One), (Building Two) etc.

This forms the basis of the Sheet in the Compiler called "Comparison". The formulars in this Sheet does not fit this type of project. It simply adds up the years as shown in the sheets. So it adds Building One with data 2014; Building 2 with Data 2015 , Building 3 with data 2016 etc ( hope I am making sense).

I need the formular to add Building One ( Column 2014), Building 2 (Column 2014), Building 3 ( Column 2014), Building 4 ( Column 2014). It does not do this because each project start in a different year. I cannot get my original files to start in any other year other than the real project start date. When I pull in the data, it pulls it in exactly how the originals are.

So I tried to add extra columns to the Building Sheet so that the years would match and I could change the formular in the Comparison sheet to just add correct across the years for each Building...and there the macro stopped working. It would not allow me to pull in any data at all, if I had to make new changes in my original file.


I guess there may be several solutions to this problem and I hope someone can help me fix this. I hope I wrote this clear enough. Please see link to files. Oh for the files to work together, they need to be saved in one folder. Thanks so much in advance.

https://app.box.com/s/qic0ru4ghwfv4v7fke23
https://app.box.com/s/h6sq7wjfd4ysqyzj1qnw
https://app.box.com/s/5evr1me7dyjzslf9jvnb
https://app.box.com/s/4kajc8kd8oz8wj5f2jds
https://app.box.com/s/nf93o7rg9zrob00qpk6b
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,122,335
Messages
5,595,573
Members
413,996
Latest member
mabelO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top