How to reference Excel information onto other sheets

maryly_dominguez Posts 1 Registration date Wednesday September 16, 2015 Status Member Last seen September 16, 2015 - Sep 16, 2015 at 11:40 AM

I have imputed all the information onto excel sheet 1, now I need to consolidate all the information from this sheet onto another excel sheet 2. I need to pull data from excel sheet 1 onto excel sheet 2 based on project locations so that they can generate a monthly total.

Excel sheet 1 shows all the data based on what is reference on the invoice excel sheet 2 needs to be consolidated based on project locations and dates how can this be done?

I really hope I'm being understood.