![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Reducing Excel File size
- or -
Post a project like this3102
£50(approx. $64)
- Posted:
- Proposals: 3
- Remote
- #1001242
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the business: Helping Farmers
Industry: Business
Description of excel work: One Excel Spreadsheet automatic feed from Quote vendor!
Second Excel Spreadsheet has a data worksheet and then 4 data entry sheets (4 products) and 4 sheets which are to be saved as Pdfs.
I have gone as far as I can possibly go and need help with the formulas to try and reduce the file size.
(The 2nd will be then duplicated and each individual customer's data will be added.
Extra notes: The 1st Spreadsheet is only 1.4MB and will increase slowly as more data becomes available.
The 2nd is 17MB (Was 22MB before I replaced vlookups by index match).
The 2nd I want to reduce in size and then save for each customer. So in theory may have 30 files.
(We do want to develop software, but we need capital before doing this).
I am very happy to send files via Dropbox!
Thinking it will take 2-3hrs work as once one section is done the others can be copied over quite easily.
Industry: Business
Description of excel work: One Excel Spreadsheet automatic feed from Quote vendor!
Second Excel Spreadsheet has a data worksheet and then 4 data entry sheets (4 products) and 4 sheets which are to be saved as Pdfs.
I have gone as far as I can possibly go and need help with the formulas to try and reduce the file size.
(The 2nd will be then duplicated and each individual customer's data will be added.
Extra notes: The 1st Spreadsheet is only 1.4MB and will increase slowly as more data becomes available.
The 2nd is 17MB (Was 22MB before I replaced vlookups by index match).
The 2nd I want to reduce in size and then save for each customer. So in theory may have 30 files.
(We do want to develop software, but we need capital before doing this).
I am very happy to send files via Dropbox!
Thinking it will take 2-3hrs work as once one section is done the others can be copied over quite easily.
![Simon B.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/5222b14f04d33ba1c81e02dc1b585822_150x150.jpg)
Simon B.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
100%
Last project
27 Jul 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies