One data entry for differently sorted lists
I created a log of clients, including date of service, type of service, amount due and paid, and source of payment. Obviously having lists sorted by client, source of payment, or type of service is very useful. Can I input data to the log of clients and have it automatically reflected into the other sorted lists? I am trying not to have to recreate the other lists from scratch each time I enter data. Thanks for your help.
Hi JerzyK and welcome to the forum,
I believe you should do this problem backwards from what you suggest. Put all you data on a single sheet. Then use Filters or Pivot Tables to sort or add the data you want.
Look at http://www.jkp-ads.com/articles/Excel2007Tables.asp for a first step.
One test is worth a thousand opinions.
Click the * below to say thanks.
Is this an excel or an Access question? It is difficult to determine from your use of nomenclature. If it is an Access question, you should use queries joining tables on common value fields.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks