i have a spread sheet 32 columns in length and if column b = paper then i
want the cursor to move to column h after i have entered details from column
a to column d and then if column b = book then i want the cursor to move to
column m and so forth.
i tried to use the if function in column e but could not get it to work.
Is there a formula or a function that i can use to do this instead of moving
the cursor manually.
I can work this using f5 and putting in the column and row number but i was
wondering if there might be a more productive way of doing it
thank you