Hi All, I'm quite new to excel formulae and am trying to crate a new order request form for my workplace as I order ink cartridges very regular and have to manually type these up every time.
I have attached a example of where I have got up to where sheet 1 has my order request form which will calculate my costings but I'm trying to link column A & B to the second sheet (renamed items)
What I would like is to create a dropdown box in column A to select the code from column A on sheet 2 so that it auto fills the description in on column B from column B on sheet 2.
I can get the dropdown box for column A to work but can't figure out how to populate Column B from this.
Any help would be greatly appreciated.
Thanks
AaronORDER REQUEST MASTER 2013.xlsx
Bookmarks