I have a EXCEL report that I need deduped, sorted and totaled all with a macro. Very simple speadsheet, nothing complex.
I need that spreadsheet published to google docs.
Every day several people collaborate on this and will make comments online in google docs in a comment section of the excel spreadsheet.
Every day a new excel file will be uploaded BUT I NEED TO RETAIN THE COMMENTS FOR THE LINE ITEMS MADE IN STEP 3. The comments must be saved to the same line item as they were before.
Full Description of this project:
I am a car dealer, and the excel report I'm working with is called a "contract in transit report" or CIT report. It is an account receivable report and shows what bank (when a cusotmer finances a car and the bank owes us the money for the car) or what cusotmer (we sold a car but the customer didnt pay the dn payment yet) owes us money.
So this report is the total receivable due from the banks (account 205) or the cusotmer (account 210) in the attached spreadsheet.
Every day, the managers collaborate on what is needed to "get a deal funded" meaning get the bank to pay us for the contract we sent them. So when the value of the account receivale is zero, that means we got paid and it needs to fall off the list. If there is a value, that means they still owe us money.
A new contract in transit(CIT) report is generated daily showing what banks or customers still us money. I need the make sure the COMMENTS on the Google Docs spreadsheet on the unpaid deals are appended to the new uploaded spreadsheet.
So I want to upload the "Raw Data" which will be in excel format, and then whatever is created needs to automate the rest of the process so it publishes to google docs or other colloboration web page where our comments can be added and stay added until the value is zero, neaning we got paid for the deal.
20 freelancers are bidding on average $894 for this job
Hello there Sir, We are a team and have great experices in Xls, Googledocs and virtual works. Please read PM for more information. Thanks.
@@@@@@@@@@ Hello Sir/Madam, we are ready to start work asap... so please check pm. Thanks San Infotech @@@@@@@@@@
Hi, I have got few questions for you. Please refer PMB.
Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards
I am ready to start working, so just send over more details and I can start.
Hi! I'm ready to start right now. This simple work will be done in two days
Randy, it was nice to hear about your technical specification although you belong to sale purchase. Since quality work deserve worth, my quotation is apt with respect to the time required to finish the project. Hope yo Daha Fazla
Hi there,I have an advanced diploma in Excel Spreadsheets and would be able todo this for you on an ongoing basis without any problem. Pm me to talk about the project further, Regards, Chris
Hi There, We can prepare this for you. Even after your approval of our work, we deliver the service for this project at no cost such as more questions or concerns or updates. Our quality of deliverable is high and o Daha Fazla
Create an Excel plugin which will consume GoogleDoc web service so your Excel worksheets can be synced based on your current requirement. Google already provides the API for that purpose.