Hi all,
I'm pretty green at this and have never done this unsupervised, would appreciate any assistance.
I'm trying to make the insert statement look like this:
insert into stk_location (Item_Code, Whouse_code) Values ('column J', 'VN09')
I'm entering it like so but Excel throws up an error:
="insert into stk_location (Item_Code, Whouse_code) Values ('"&J3&"', 'VN09')
'"&J3&"' is from within the same sheet, but all other items are text.
thanks