var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
i have a code for each row of data in one sheet , but i dont know how to, when i go on to a different sheet, link it up so that when i type in that code that row that it corrisponds to will be copied and pasted to where i want it to be.
Just a thought, but have you looked at VLOOKUP in the help file?
yes thanx but i still wouldnt know wot i would be writing in. i will add the attatchment so you see wot i mean
See the VLOOKUPS that I added.
thanx but this isnt what i quite wanted. i wanted to type the code in the table and the description, size, price, and qty would appear
Last edited by ben2001; 01-28-04 at
That's what happens with what I posted.
Try deleting the code and see what happens. Then type the code back in.
If you want to get around the #N/A error message, adjust the formulas as so:
=IF(ISNA(VLOOKUP(Lookup Range, Source Range, Column Index, FALSE)),"",VLOOKUP(Lookup Range, Source Range, Column Index, FALSE))
Here you go.
Note comments in Blue.