Excel/Time Worksheet macro needs to be created to fix broken excel sheet links
- or -
Post a project like this2050
$
- Posted:
- Proposals: 6
- Remote
- #2108482
- Completed
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
22674773549564986569457611046302191877
Description
Experience Level: Entry
Hi,
We have two worksheets.
1 Main Sheet - where we automatically write down hours with RFID tokens per employee.
2 Manager sheet - which retrieves info from the main sheet (because it can only be opened one time. If a manager thinks the hours are wrong, he overwrites the cell in this sheet to calculate the month/weekly hours.
Currently sheet no.2 is broken because the sheet link seems to be broken. it point to a local C:\ folder and not to the network anymore (T:\Data\Application\TijdregistratieManager\Sheet.xlsm...)
I think a macro a macro needs to be created to fix this because there are many formules which include this invalid local path. We would be prefer to have a excel vba function which has a source/target variable for fixing this in the future as well.
Remote work is possible via teamviewer during working hours, excel files can also be sent (also to make a quotation).
Regards, Rick
We have two worksheets.
1 Main Sheet - where we automatically write down hours with RFID tokens per employee.
2 Manager sheet - which retrieves info from the main sheet (because it can only be opened one time. If a manager thinks the hours are wrong, he overwrites the cell in this sheet to calculate the month/weekly hours.
Currently sheet no.2 is broken because the sheet link seems to be broken. it point to a local C:\ folder and not to the network anymore (T:\Data\Application\TijdregistratieManager\Sheet.xlsm...)
I think a macro a macro needs to be created to fix this because there are many formules which include this invalid local path. We would be prefer to have a excel vba function which has a source/target variable for fixing this in the future as well.
Remote work is possible via teamviewer during working hours, excel files can also be sent (also to make a quotation).
Regards, Rick
Rick B.
100% (4)Projects Completed
4
Freelancers worked with
4
Projects awarded
50%
Last project
5 Jun 2019
Netherlands
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Rick
Could u please share excel files for better understanding of the task?Rick B.15 Aug 2018Hi Muhammad, ofcourse! One moment
694172
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