Copy certain columns of a row to a new sht IF

Microsoft Office excel 2007 home & stude...
September 23, 2010 at 12:43:42
Specs: Windows Vista
I have an excel sheet that I have made and i would like to copy some of the columns in each row to a new sheet if column K is blank.

So I would like columns A, B, C, D, E, I, J, M and N copied to sheet 5 IF K is blank

Then I would need it to be sorted by column B with a secondary as A


See More: Copy certain columns of a row to a new sht IF

Report •


#1
September 23, 2010 at 13:52:03
Thanks for letting us know what you'd like and what you need.

If you need any assistance, feel free to ask for help.


Report •

#2
September 24, 2010 at 05:09:45
Okay, sorry - no need to be that way.......

Here, you should enjoy this better. :) (no l*k* or n**d in sight)

<><><><><><><>
I have an excel sheet that I have made and i wish to know how copy some of the columns in each row to a new sheet if column K is blank.

Only columns A, B, C, D, E, I, J, M and N copied to sheet 5 if K is blank

Then is it possible that sheet 5 be sorted by column B with a secondary as A

Any assistance would be greatly appreciated
><><><><><><><>


Report •

Related Solutions


Ask Question