Arthurwdodge
New Member
- Joined
- Feb 26, 2013
- Messages
- 1
My business sells goods for up to 30 individuals on consignment. At the end of every week we want to import some various columns from our point of sale records to a worksheet what has a running total of sales. Each vendor has anywhere from 1-40 unique items.
We are hoping to have this all running in google spreadsheets with individual receipts for each vendor that auto populates as we add data to the sales spreadsheet by the week, so that a vendor can at anytime access their records online. We know that this is possible, but are lacking in the knowledge to do so.
We are hoping that this can easily be setup so that we can go into a master list at anytime and change,edit, or delete things (ie, commission, product names, prices, unique vendor #, vendor, etc) without altering any formulas. Is this possible, and is anyone willing to help us? We would like to compensate someone who is willing to walk us through this.
the way we are doing this is cumbersome, and takes entirely too much time as is.
Thanks for your time
-regards
We are hoping to have this all running in google spreadsheets with individual receipts for each vendor that auto populates as we add data to the sales spreadsheet by the week, so that a vendor can at anytime access their records online. We know that this is possible, but are lacking in the knowledge to do so.
We are hoping that this can easily be setup so that we can go into a master list at anytime and change,edit, or delete things (ie, commission, product names, prices, unique vendor #, vendor, etc) without altering any formulas. Is this possible, and is anyone willing to help us? We would like to compensate someone who is willing to walk us through this.
the way we are doing this is cumbersome, and takes entirely too much time as is.
Thanks for your time
-regards