i have a list of 1000 pieces of equipment (Site Code, Make, Model, Sernum)on Sheet1. On Sheet2 I would like to select a Site Code then display on items on Sheet1 (by Site) See example. Photo show only a one sheet view.
i have a list of 1000 pieces of equipment (Site Code, Make, Model, Sernum)on Sheet1. On Sheet2 I would like to select a Site Code then display on items on Sheet1 (by Site) See example. Photo show only a one sheet view.
Hi and welcome to the forum
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)
To pull data from 1 place to another, you would normally use vlookup()_ or index/match. Take a look at those and see if that will get you started?
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
As request
hmm OK that was a bit different from what I was expecting. Walk us through how you would create that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks