Hey Guys,

I have been through multiple forums and cant find what I am looking for. I have tried my best at userforms/input forms and straight Excel sheets.

Information layout:
sheet1
-- list lookup on a defined name in sheet 2
-- some vlookups in cells to allow the user to confirm they are looking at the right item
-- 3 x input cells that will be updated in sheet2 based on an action (submit button)

sheet2
--raw data

-- the user will essentially use the list lookup cell to select a item
-- confirm they selected the right item (vlookups)
-- then enter some data into the 3 input cells
-- press a submit button
--## EXCEL - funky VBA then uses the selected list item in sheet1, takes the new data in the input cells (sheet1) and copies these into the sheet2 into the appropriate columns based on the selection in the list lookup on sheet1

This is now green fields as I have gone through too many other peoples code and try to make it work - so I have given up and asking for help now :-(

I am happy to host a form on the sheet2 if that makes it easier, or have it as standard fields on another sheet...

TIA
Lee