Hi all,
First off, I am sorry for the title that is probably not clear. I have recently started to understand what VBA does and why it can be powerful. However, I have never learnt programming, and I find it a bit difficult to suss out. I would therefore be really grateful if someone could help on this.
I have indeed looked up for solutions in tutorials, books etc. and i have not come across a solution for this:
What I would like is basically a code that makes a workbook to run a sort of log book, or similarly behaves like an inventory.
I would need a bit of code, that looks up in table using an ID #, and write data in the right cell.
The purpose of this is for consulting and UPDATING matters in order for users to access information based on an id, and also update the information from a dashboard rather than going to the database.
I find it a bit difficult to explain... I hope the document I have attached will make sense.
The code I have written so far is just what a classic vlook up would do, but since i need to update the fields, I need these to contain my content and not the formulas. (Hence i need VBA)
I have put some more details in the spreadsheet.
I would be extremely grateful if somebody could give me a hand on the code, point out a tutorial / forum post etc.
Cheers,
pierre
Bookmarks