How do I reverse a spreadsheet that is in the format of a subtota.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that details transactions by vendor but there is one
line for the vendor and the detail transactions fall below the vendor line.
The detail transactions do not show the vendor name. I need to have the
vendor name on each line of the detail so I can sort and analyze the data.
This is actually a report exported from QuickBooks. The only option I see is
to copy the vendor name to each detail line and then remove the original
vendor line. This is a lot of manual labor for a pretty large spreadsheet.
 
Frank,

Check this out...
http://j-walk.com/ss/excel/usertips/tip040.htm
"Duplicate repeated entries in a list "

Regards,
Jim Cone
San Francisco, USA

----- Original Message -----
From: "Frank DiPietro" <Frank
(e-mail address removed)>
Newsgroups: microsoft.public.excel.misc
Sent: Tuesday, January 18, 2005 6:25 AM
Subject: How do I reverse a spreadsheet that is in the format of a subtotal.
 
Thanks Jim. That worked great!

Jim Cone said:
Frank,

Check this out...
http://j-walk.com/ss/excel/usertips/tip040.htm
"Duplicate repeated entries in a list "

Regards,
Jim Cone
San Francisco, USA

----- Original Message -----
From: "Frank DiPietro" <Frank
(e-mail address removed)>
Newsgroups: microsoft.public.excel.misc
Sent: Tuesday, January 18, 2005 6:25 AM
Subject: How do I reverse a spreadsheet that is in the format of a subtotal.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding cells in autofilter 1
Find partial match from column A,B and fill partial match in C? 4
rows.... 3
Import data to a spreadsheet. 1
Spreadsheet with data on two lines 3
SubTotals on Forms 7
Importing a multiline .txt file 13
How do I reverse name order from Last, First to First Last in Exc 3

Back
Top