LinkBack URL
About LinkBacks
In sheet 1, you have your information. In sheet 2, if the user where to enter 3 in A2, then I need the category and the name to populate based on the user input from sheet 1
In sheet 1, you have your information. In sheet 2, if the user where to enter 3 in A2, then I need the category and the name to populate based on the user input from sheet 1
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet1 and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter a number in column A of sheet2 and press the RETURN key.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks