Hello All,
Sheet1 -Daily ( Tab->Jan-20)
Sheet 2- Weekly ( Sat - Fri)
i want sheet 2 for the whole year weekly summary which will will pull data from daily sheet( Jan-20).
I just want to pull the data of each company for each day and date and take it to the summary sheet.
It seems like very frustrating because if i try date or day look up but they are merged it only pulls data from the 1st column of row .
I have attached an example i hope you will understand what i`m trying to say -
Thanks.
Last edited by tauceph; 11-05-2019 at 12:22 PM.
I am confused...
Please populate the sheet with some manually calculated expected results AND tell us which is the raw data and which is the expected results...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks Glen
i attached another file highlighted the data in both sheet .
Jan-20 is the manually working sheet and sheet weekly will pull the data for the same date and day from that jan-20 sheet .
I need to use a function instead of connecting both sheet with the reference.
Each column form AW to BB has a slightly different formula. Here's one:
=INDEX('Jan-20'!$G$6:$FE$6,,MATCH(AW$4,'Jan-20'!$G$2:$FE$2,0)+ROWS($1:1)-1)
they're all similar, though. Then select ALL cells: AW6:BE9 (I do mean BE, not BB), copy and paste into BF6, BO6, etc.
Thanks Glen you are the man . Appreciated.
... and you are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks