This is a simple trial project. If this works out there will be more projects to offer.
I will provide an excel sheet, in which among other tabs there are three tabs called:
Raw Mat – BOM (Bill of Material....Just in case you are beginning to doubt)
Raw Mat – Cost
Raw Mat – Cost Default
Column D, I, L & M in Raw Mat – COST is linked to various cells in the whole worksheet.
To eliminate the need for the tab Raw Mat – COST, I have included those columns in Raw Mat – BOM. The same columns appear at Column BA, BB, BC & BD.
I want all the links to Column D, I, L & M in Raw Mat –COST to be linked to Column BA,BB,BC &BD in tab Raw Mat – BOM.
After the work is done, a final check should be carried out to ensure this is correctly done. The check will involve saving your work first and then deleting the tab Raw Mat – Cost. By doing this it should not upset the workings in the file.
I will provide the files, once I receive the bids and shortlisted the freelancers.
Thanks
Greetings -
I understand this project's requirements are to update many linked formulas which are currently referencing a sheet which you would like to remove, in order to save space/filesize in the future.
It should be possible to update the linked formulas programmatically using VBA in Excel, to ensure they are updated correctly and accurately, and that none are missed or overlooked.
Thanks for considering my bid, I look forward to hearing from you.
Regards,
David
$49 USD in 2 days
5.0 (2 reviews)
1.8
1.8
8 freelancers are bidding on average $45 USD for this job
Hi there,
I've had a read through of your requirements and I have mapped out what is required based on my understanding.
Please contact me and send me the file so I can provide you with the output. Very keen to maintain a working relationship for future projects!
Cheers