One lead page used for multiple sheets
Hi
Does anyone know if it is possible to create a spread sheet of clients names and addresses on sheet 1 and then create further sheets with different information on, but use the first sheet name and addresses to relate to the other sheets.
Hope this makes sense.
Of course, and through many ways.
Data Validation Lists can be used to feed dropdown menus, and formulas other sheets such as VLOOKUP, INDEX(..MATCH, and LOOKUP be used to retrieve data based on the your parameters.
If you attached an example of what you'd like to try, I am sure someone could show you how to fill in the blanks.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks