AgTalk Home
AgTalk Home
Search Forums | Classifieds (59) | Skins | Language
You are logged in as a guest. ( logon | register )

Excel spreadsheets- can you have a master and then some sorts that feed off master?
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Seth_ia
Posted 6/18/2019 19:51 (#7567077 - in reply to #7562504)
Subject: RE: Excel spreadsheets- can you have a master and then some sorts that feed off master?


Yes it can be done in excel. With out seeing your sheet, I’m guessing you would have to design some type of look up table. Pivot tables are useful for reporting but depending on how you add products and differentiate things they may not be flexible enough.

The best answer is not excel. Access is a much better choice. It’s has the inherent ability to store data in master tables then query it and report it by customer or any other parameters you need.

New versions of access our much easier to build than the old ones.
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete all cookies set by this site)