UpDated... How to Change Row Offset in pasted formulas

[gene_sc]

Hi All-
I am using excel 2000 to import and format a tab delimited txt file(*.txt will always be in the same format) for import to QuickBooks
I am looking for a way to sort columns into a different order-on a new worksheet(I have tried using Named Ranges and refer to them on the new sheet)- but seem to missing something - I am looking to automate this step in conversion of the text file
thanks for your time in answering my question
regards gene
This message was edited by gene_sc on 2002-08-25 10:38
This message was edited by gene_sc on 2002-08-28 18:29

 

[gene_sc]

Still looking for help....
how to increase row offset every time a formula is pasted
thanks gene