• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

Excel Vlookup to move data back to source.

Can Vlookup be used to display a value from another sheet then also update source when you input into that vlookup cell/?
I have a simple dummy file that spells everything out.

The drop down pulls in the operator name,then the vlookups in the small tables display the data from the main sheet. (I know I could probably could use a Pivot Table, but I am better with simple VLookup than Pivots)

Inside each table I would love to be able to input data and it would update the main data sheet with a push of the "update button".
A confirmation "Yes/No" prompt should be used if possible.


Thanks so much.
Book1.xlsx
0
chris pike
Asked:
chris pike
  • 2
  • 2
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Please find the attached with the codes added so that if you change the dropdown selection in B5 on Dash sheet, the data from the Master Log will be extracted onto the Dash sheet and after updating the data if you click the Update button on Dash sheet, the Master Log will be updated accordingly.
Chris.xlsm
0
 
chris pikeAuthor Commented:
Thanks Neeraj,
Works great, Awesome work.
    Curious, in the Dash, seems like I have to fight to get the cursor to move.
It's like it gets stuck.

Oh... And how hard is it to add another category to the bottom, would it be something that I could do in the future? I don't need it right now. but perhaps in the future.
Thanks so much.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You will of course need to tweak it if you add more categories. If you pay attention to the loops and ranges being copied, you will certainly get an idea about the algorithm used in the code and will be easy for you to tweak it then.
0
 
chris pikeAuthor Commented:
Awesome work, first time, and it works great/....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now