Hi gurus:
Here is my problems:
Four tabs.
1. Tab " Monthly EE Listing" is the file updated each month. Information updated are from column A to AB. Column AC- AH were added columns
with basic formula to calculate adjustment based on the monthly information.
2. Tab " Pivot" is the simple pivot table based on " Monthly EE Listing" tab
3. Tab " SP&A Data" is basically recap of Pivot with better format
4. Tab "JE" is the information from Pivot, currently manually enter and pull from pviot by account number for each projects.
Information reside in the tab are partial right now, i didn't pull everything, just as example.
5. Tab "YTD" basically is the file to capture information from "Monthly EE Listing" tab, and keep adding with each additional month.
Action needed:
Tab really needs to work on is " JE" Tab. Is there a way using offset or match to have formula in place so that once the pivot table
refreshed each month, all information can be automatically populated by account number. There are 33 project numbers and 5 accounts. so
right now, i have to do 33x5 times to pull the number in.
Secondly, anyway to automatically add new month information to the YTD tab each month?
Thank you somuch
Bookmarks