Formatting my column? PLEASE HELP

  • Thread starter Thread starter cjandc
  • Start date Start date
C

cjandc

I have an excel worksheet with 64000+ records. These records need to be
grouped together by document ID in column A. Right now they are all
smashed together and I wanted to know if I could use VBA to format this
first column so that it compares the document ID numbers and inserts 3
rows when there is a change in document ID to separate the new document
ID number from the previous ones.
 
Well, this is brings some questions to mind. I have seen many spreadsheets,
but do not know what "smashed together" means. Assuming you know how to use
VBA you must know the capabilities and limitations. Generally it is better
not to have blank rows within your data.

Have you looked at Data>Subtotal? That is one method to group by a field,
such as ID.
 
Sorry about the fuzziness. Actually what I am trying to do is put this
worksheet in a format that another program called Optix can read.
Optix is a SQL front. It communicates with databases, and this program
has a certain format it needs to read a spreadsheet.
What I meant by smashed is that there are no spaces between any of
the rows and I need them there in order to read the file with Optix. Oh
and no, I don’t have any experience with VBA. I thought maybe there
was some simple code I could learn to do this. The only thing I know
how to program with is Microsoft C.
 
Back
Top