I have a few excel files i want to replicate the manual process we do in excel automatically by using in MSFT Access. I want to have an SOW template that can be replicated multiple times and every replication totals into the summary sheet filling in the same data points as the excel file shows. The individual SOW tabs funnel totals into the chargeable and non chargeable tabs . The excell sheet is what i need replicated in Access. But i want Access to be a much more straight forward process without having to worry about picking up the wrong cell or manually putting chargeable SA's in the chargeable SA tab and manually putting the non chargeable in the non chargeable. The template of the SOWs should have the following added fields . these are not in the excel file but they are in the header of each tab. The contractor, the SOW name , the Description of work, a column for chargeable and non chargeable.( this will determine what summary sheet the SOW filters up to) a column to attach a file and a column to assign a resource from an existing employee list. The individual SOWS will be printed out and emailed along with pdf copy of the contract. Acccess you can email attach files and select from a list all without having to do the multiple steps if you were to use outlook and excel and PDF independently. Once the individual SOW is created it rolls up int the . I do not want you to use the access file i attached this was a failed attempt to use a template. I want you to look at the Chargeable tab and the SOW template tables. It is hard to convey but someone should understand what i am asking for.
4 freelancers are bidding on average $194 for this job
Hello, I would love to work for you. This is my first work in freelancer, so I want to do my best. May i get lucky to work for you? Looking forward to your response. With regards. Angel