Good morning.... First time on Excel Forum. I'm hoping to get some assistance on an Excel task I'm working on.
I have a Excel 2010 spreadsheet that lists out two type of food categories. If 'bakery' or 'prep foods' are listed anywhere in column A, I want the contents of column B thru G to automatically populate in column I thru N. I have several categories but I'm confident if I can get help moving one, I can get the others to move to their respective column.. Easy? I hope so!!
I've added an image that should help us.
Thanks!
Bookmarks