Hi all,
I'm not very much familiar with VBA. so I need help.
Could you please help me to extract data of a specific date using calendar from sheet1 to sheet 2.
Please see attached file for detail.
Regards
Hi all,
I'm not very much familiar with VBA. so I need help.
Could you please help me to extract data of a specific date using calendar from sheet1 to sheet 2.
Please see attached file for detail.
Regards
Hi,
Does it have to be a macro?
See attached.
A series or formula's that index the data.
Just change the date in cell M27.
Hope this is helpful
@ southward, nice. You can shorten that formula using IFERROR...
=IF(ISERROR(INDEX($A$1:$D$26,SMALL(IF($D$2:$D$26=$M$27,ROW($A$2:$A$26)),ROW(1:1)),1)),"",INDEX($A$1:$D$26,SMALL(IF($D$2:$D$26=$M$27,ROW($A$2:$A$26)),ROW(1:1)),1))
becomes...
=IFERROR(INDEX($A$1:$D$26,SMALL(IF($D$2:$D$26=$M$27,ROW($A$2:$A$26)),ROW(1:1)),1)),"")
However, I have a feeling this is going to be a huge range - 25 rows for just 4 days, and all those ARRAY formulas may slow te file down. Based on that, and using your example and a helper column to eliminate the ARRAY formula.
E2 (,y helper column=COUNTIF($D$2:D2,$M$27)
copied down
Then to extract the data...
K28=IFERROR(INDEX(A:A,MATCH(ROWS(A$1:A1),$E:$E,0)),"")
copied down and across
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
Hi,
Can someone help me with VBA please.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks