LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 211
Default Invoicing Capability

Any help appreciated.

I have a database of information in Excel that needs sorting automatically
into auto generated tab sheet invoices based on values in Column A.

I have 60 Food Manufacturers populating column A with 900 entries. eg.
Cadbury appears randomly 80 times, Birds eye 30 times etc etc... I need new
sheets to be generated automatically for Cadbury, all products associated
with Cadbury listed on the sheet along with it's unit price and cost price.
Then another for Birdseye and all other manufacturers and products, without
repetition. This programming would generate 60 sheets, each being
automatically named Cadbury etc etc.

Is this easy to do, or is it best doing this in Access.

Thanks

Gordon...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search Capability Dreiding Excel Discussion (Misc queries) 1 April 23rd 10 09:32 PM
invoicing tourpro Excel Discussion (Misc queries) 2 April 24th 08 06:31 PM
Look-Up Capability Tampa-Terry Excel Discussion (Misc queries) 2 August 17th 07 02:22 AM
invoicing Toppers Excel Programming 0 February 4th 06 02:14 PM
Invoicing Sir Paul Excel Worksheet Functions 0 January 12th 05 04:01 AM


All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"