With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, January 5, 2016
yogi_Pull Row By Row Matching Items By Month And Category From Import Sheet
I'm trying to write a formula that would go in the "Forecast" Sheet that pulls from the "Import" sheet.
The import sheet is copy and pasted from an accounting system report.
The forecast sheet is a budget sheet where the budgeted numbers get updated each month with the actuals from that month, but the rest of the columns remain budgeted amounts. We are trying to find a formula that could update these automatically by matching the account name and the month of the data regardless of the format of the accounting system report.
I would like the formula to match on the account name (i.e. Sales, Travel, Office Supplies, etc.) and the month. The accounting system report puts the months in reverse order, and we would prefer not to have to rearrange these each time.