Hi.
I have attached a spreadsheet with an example to help. I need to be able to budget data automatically from different spreadsheets based on a Date in the main sheet. So if the date is 1-Mar-2016, it needs to go to the '2016 final budget' tab and pull data for march. If I change the date to 1-Mar-2017, it needs to pull the march data from the '2017 Final Budget' tab. Is this possible?
Put this in cell E3 and pull down
Formula:
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Hi Mike,
thanks for the quick response. I tried to copy the formula into my real file and realized some of the cells were in different places. Would you mind doing the same thing on this file attached? I tried to correct the references myself but now it won't work.
Maybe this
Formula:Please Login or Register to view this content.
Still not working. Is that the same formula?
I appreciate the help, by the way.
Check the new file i uploaded.
No it is not the same formula. What do you mean by still not working? Just a quick look I took showed it was pulling the wrong column. So removing the -1 at the end returned the correct column.Originally Posted by realestateman
My bad lol... yes it was the same formula. Your modification was only lacking removing the -1 at the end of formula
Formula:Please Login or Register to view this content.
I got it!! Thanks for your help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks