Auto Complete Fields in Sheet 1 based on Sheet 2 information
Hello,
The first column of my spreadsheet is priority (values are 1,2,3 etc.). Each row is it's own task with its own priority. I would like to create a new sheet, and auto pull in ONLY Priority "1" items. I tried to do this using VLOOKUP but it will only look for values that are unique, while I will have many priority 1 rows. Is there a formula to do this that I can use?
Thanks!
Heather
Hi Heather,
Welcome to the Excel Forum!!!
To get answers quickly and for better understanding of other people, kindly upload your raw file. So people can response on your query quickly. To know more how to upload the attachment, please see below response..Also take few minutes to read our FORUM RULES
Attach A File.jpg
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
The following Sub will automatically filter column A on 1, copy the results and paste them in Sheet2
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
Thank you - sorry for the very basic question, but where do I enter this sub?
Also, I am trying to use Google Sheets, rather than Excel. If you know how to do this in that application that would be fantastic.
Heather - Google have different compatible settings and VBA codes will not work there....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks