Solved

Excel Vlookup to move data back to source.

Posted on 2016-09-02
4
83 Views
Last Modified: 2016-09-06
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
Comment
Question by:chris pike
  • 2
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 total points
ID: 41782552
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
 

Author Comment

by:chris pike
ID: 41786142
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
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41786425
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
 

Author Closing Comment

by:chris pike
ID: 41786446
Awesome work, first time, and it works great/....
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now