Automatic excel workbook duplication
- or -
Post a project like this2717
$$
- Posted:
- Proposals: 10
- Remote
- #1334754
- Awarded
Business tools for today's environment using Excel, Access & VBA scripts...
Stoke-on-Trent
MBA Global Business Strategy, Export Bussiness Developement, Study Methods Teacher, Excel Developer, Amateur artist, Seller,
Lima
Financial Modeler | Financial Analyst | Start-ups | Real Estate | Merger & Acquisitions
Gurgaon
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
139184211042403661753621102532712671401281859140055314064161416062
Description
Experience Level: Intermediate
I have a excel workbook with several worksheets in it.
we are an IT Hardware sales company and this workbook is split into sheets that contain several columns one each for product number, description, retail price, trade price, cost, notes regarding product, condition etc.
When sales people want to send a customer a sales list they have edit this list to hide cost price and notes. Can we have another excel workbook that is automatically updated with only relevant columns i.e just taking the part number description and condition and price.
we are an IT Hardware sales company and this workbook is split into sheets that contain several columns one each for product number, description, retail price, trade price, cost, notes regarding product, condition etc.
When sales people want to send a customer a sales list they have edit this list to hide cost price and notes. Can we have another excel workbook that is automatically updated with only relevant columns i.e just taking the part number description and condition and price.
JAS D.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
29%
Last project
4 Nov 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Jas, please share the sheet and sample so I can perform the task and send it across to you
-
Dear advirtiser,
Hope You are well . Here I studied your post and your requirements , I think you should use a online spredsheet like google sheet. where all data will be uploaded and can be hidden as you desire, also the customars only can view this won't edit .
Regards,
Bikram
204308202741
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