Hi,
i have a spreadsheet where the front page (which is printed) is formated with a barcode font.
the number for the barcode font is copied from the second sheet where the data is imported.
I would like to add a YES/NO column to this 2nd sheet beside each corresponding record.
what i would like to do is if the column in the 2nd sheet = NO, it alters the barcode font to a normal font on the first page and enters the text "N/A"
obviously, it would have to loop through each row in the second sheet and format the corresponding cell on the first sheet.
it's been a long time since i've attempted this and it's starting to hurt my head lol!
so any help or pointers would be appreciated.
kev