Cell Format help

[jon v]

Here at work have to use excel set up internal quotes, but when you copy/paste into the area where the item # goes into, you have to copy each line individually, and then repaste. Or you can use paste special, and select text, then you can double click and it will populate the description. Do you guys know of a way to just copy and paste so it will activate the cells? If I do that now, I have to go in a copy paste each item. I just need inactive pasted cells to be active so they will populate the item description on the next cell automatically without me going through the effort of fixed each line item individually!

Thanks in advance!

jon

 

[qafself]

Hi Jon,

Sounds like you need to use VLOOKUP to populate the cells - can you attach a sample sheet so that we can better advise you?