Dec 29 2020 05:45 AM
Here's what our group does,
Our Sales worksheet headings as follows:
CUSTOMER NAME: >>> Enter Customer Name
AMOUNT: >>> Enter Value of Order ( this totalled in another Workbook)
ITEM A: Enter AMOUNT in A,B or C item ordered. ( totalled in another Workbook)
ITEM B:
ITEM C:
What we are trying to do is that when we enter the AMOUNT of the order that amount is automatically
entered into another tabular worksheet under Customer Name giving a running total.
At the moment we do this manually by switching between workbooks and entering data into customer form , but is now getting time consuming as the volume of orders are increasing
We have approx 15 customers we are tracking this way.
So how can we achieve this "dual" entry of data into Sales and Customer workbooks???
Dec 30 2020 06:51 AM
Is it possible for you to post a copy of the workbook(s) you have? If it contains confidential data, then create a fictionalized version that replicates the layout and organization.
I ask in part because--from what you've written already--I suspect that there may be another way, possibly several ways, to organize the work, making a clearer distinction between the processes whereby you collect the information and enter it (the Input end of things), and the Output--those customer specific summaries. As you are sensing, it shouldn't be necessary to enter the data twice.
There are frequently in Excel two or three ways to accomplish a task....which way would fit best with your need depends on the bigger picture here, how you use the customer summary sheets, etc. Seeing a copy would help determine this.
Jan 02 2021 03:24 AM
We have decided to completely redesign our methods of inputting the data and integrate it with an accounts module. We found that not only did we duplicate the sales input data but also other aspects of the business.
Thanks for your interest in our problem,.
Jan 02 2021 07:05 AM