LinkBack URL
About LinkBacks
help!! attached is my worksheet. data will come from sheet 2 and will be posted in stock card sheet. i cannot generate the next line. i want to get data for tape transparent for the different dates
help!! attached is my worksheet. data will come from sheet 2 and will be posted in stock card sheet. i cannot generate the next line. i want to get data for tape transparent for the different dates
A VLOOKUP will find one value and always the same value unless you adjust the lookup range. However in this case the original data doesn't seem to be in any sort of consistent pattern which would allow a lookup.
But for this sort of stuff where you're extracting records from a database you should be using an Advanced Data filter.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
but the advanced data filter does not return the answer I should get
Hello Ligaya and Welcome to Excel Forum.
If I understand correctly the following array entered formula* will display the correct dates:Formula:
Please Login or Register to view this content.
Similar formulas may be used in columns B through E, as shown in the attached file.
*Array entered formulas are activated by simultaneously pressing the Ctrl, Shift and Enter keys.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Why ever not? The advanced filter will return all the items you define in the criteria range you set.Originally Posted by ligaya
thanks. it work excellentHello Ligaya and Welcome to Excel Forum.
If I understand correctly the following array entered formula* will display the correct dates:Formula:Please Login or Register to view this content.
Similar formulas may be used in columns B through E, as shown in the attached file.
*Array entered formulas are activated by simultaneously pressing the Ctrl, Shift and Enter keys.
Let us know if you have any questions.
thanks.
it is greatlly appreciated if sample of the solution can be attached
You're Welcome. If you are the original poster please take a moment to sign in using the 'Ligaya' account and mark the thread as 'Solved' using the thread tools link above the first post. I hope that you have a blessed day.
See attached,
Select the item in the B11 drop down. The filter macro does the rest.
sorry I'm not Ligaya
That's somewhat enigmatic. Are you saying you're not happy? And if so with what?
sorry i'm not ligaya.
Sorry i forgot to reply with quote
OK so you just posted on another member's post then?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks