Hello All,
I am trying to find a formula that will allow me to transfer the data from one data tab into a summary tab. Pivot tables don't seem to work. I thought I could do a vlookup but I need to use multiple criteria. I'm open to all suggestions. Please see attached file. Help!
Last edited by RBK2; 07-10-2018 at 10:43 PM. Reason: Adding excel file
Hard to tell from your sample what is the raw data and what you want to achieve as a result.
Maybe include some explanation....before -> after, etc.
Agree more detail is needed, as well as before/after.
Also, sheet2 has a link in it to a file on YOUR HDD that we will not have access to
A2=VLOOKUP($B2,'G:\1. Ruth - Business_Volunteer Work\[Copy of The Massive Dump of Schedule By Venue - Abi.xlsx]Lists'!$A$3:$B$13,2,FALSE)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have updated the file and removed the formula on tab 2. The information in tab one is a sample of what I am trying to achieve. I need to move the data from tab 2 into tab 1 by date and time. Does that help?
Basically I need to be able to have under the date column the activity as it will occur:
Aug 16
7:30 PM Artist Load In
7:45 PM House Load In
8:00 PM Show Start
8:45 PM Show End
9:00 PM Artist Load Out
9:15 PM Crew Break
I need to be able to repeat the process for all date columns.
Last edited by RBK2; 07-10-2018 at 10:48 PM.
See if the following array entered formula* meets your needs:Formula:
Please Login or Register to view this content.
*Array entered formulas are confirmed by simultaneously pressing the Ctrl, Shift and Enter keys.
The only place where I saw an obvious problem was with the 11:59 PM performance on Saturday. I changed that to 12:00 AM and of course saw that it causes display problems in columns I:J. It seems that columns Q:R mimic I:J so I changed the formulas in those columns to (respectively): =$D2+TIME(23,30,0) and =$D2+TIME(23,45,0)
Let us know if you have any questions.
Last edited by JeteMc; 07-14-2018 at 10:56 PM.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
1 quick question...
Do you actually want to MOVE the data...I need to move the data from tab 2 into tab 1...in other words, the cells where the data was, will no longer contain anything.
Or on tab 1, do you just want to reverence the data on tab 2?
I want to reverence the data on tab 2
OK that clears that up, thanks for the update.
Did you try the suggestion in post #5?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks