T
TinaF
I have two columns in a spreadsheet "Quantity" and "Item". I filter
the quantity column to select only the "nonblanks". After this step I
want to copy these two columns and paste them into a Word document.
Once it's in Word I want to insert a column to the left of the
quantity column and format it with "bullets & numbering" so I can
number the items 1. through whatever. Problem is, the numbering
behaves as if the blanks are still there so it skips around.
I do not want to delete the blank rows in the original spreadsheet
where the quantity is blank because they may be needed at a later
time.
Any suggestions how I can get these two columns into Word and be able
to number them sequentially?
the quantity column to select only the "nonblanks". After this step I
want to copy these two columns and paste them into a Word document.
Once it's in Word I want to insert a column to the left of the
quantity column and format it with "bullets & numbering" so I can
number the items 1. through whatever. Problem is, the numbering
behaves as if the blanks are still there so it skips around.
I do not want to delete the blank rows in the original spreadsheet
where the quantity is blank because they may be needed at a later
time.
Any suggestions how I can get these two columns into Word and be able
to number them sequentially?