Sales invoice in sheet1 and create summary table in sheet2 [Closed]

Report
-
Posts
1291
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 5, 2021
-
hi

im working on sales/inventory worksheet.
i made the sales invoices in sheet1, now i want all the details of sales invoice in sheet 2 to create automatically a table indicating all sales invoices and its details in table method...

looking forward for the help...

1 reply

Posts
1291
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 5, 2021
229
Hello Simy,

I'm assuming that you would like to create a Register or Archive of all the invoices that you generate with the Register showing details such as Client Name, Date, Amount etc. etc...

If this is so, it would be best to have the Register just show the basic details and not whole descriptions as this would be a major drain on resource. I also assume that you are saving each invoice to a separate folder so full details will always be at your disposal.

In the meantime, please upload a sample of your work book (be careful with any sensitive data) to a free file sharing site such as DropBox, ge.tt or SpeedyShare then post the link to your file back here. We can then have a good look at what you are attempting to do.

Cheerio,
vcoolio.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!