Retrieve all named ranges and formulas used in an Excel Workbook
$30
Delivery in
1 day
- Views 784
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
Have you been given an Excel workbook containing a number of worksheets, and there is a cell in one of the worksheets , containing a reference to a named range? You see the named range in the top left but when you select it, it doesn't go to that range because the sheet is hidden?
I will take your Excel file (any version, i.e. 97 to 2013 / any format, i.e. xls, xlsx, xlsm), and give you back an Excel file with 2 sheets.
The 1st sheet will have a list of all the named ranges used within each sheet.
- It will contain the range name, which sheet, cell and address it refers to, and whether or not the sheet being referred to is valid (not in the workbook, hidden (it can be un-hidden) or truly hidden (cannot be un-hidden)
The 2nd sheet will contain a list of all the fomulae used within each sheet.
> It will contain the sheet name as well as the cell reference where the formula is being used
If required, I can then produce statistics on these findings.
> Number/% of named ranges per sheet
> Number/% of formulae per sheet
> Number/% of invalid named ranges per sheet
> Bymber/% of invalid formulae per sheet
These statistics will be reported on using charts.
I will take your Excel file (any version, i.e. 97 to 2013 / any format, i.e. xls, xlsx, xlsm), and give you back an Excel file with 2 sheets.
The 1st sheet will have a list of all the named ranges used within each sheet.
- It will contain the range name, which sheet, cell and address it refers to, and whether or not the sheet being referred to is valid (not in the workbook, hidden (it can be un-hidden) or truly hidden (cannot be un-hidden)
The 2nd sheet will contain a list of all the fomulae used within each sheet.
> It will contain the sheet name as well as the cell reference where the formula is being used
If required, I can then produce statistics on these findings.
> Number/% of named ranges per sheet
> Number/% of formulae per sheet
> Number/% of invalid named ranges per sheet
> Bymber/% of invalid formulae per sheet
These statistics will be reported on using charts.
Get more with Offer Add-ons
-
I can provide statistics per sheet (i.e. % of invalid ranges and formulas - based on set criteria)
Additional 2 working days
+$25
What the Freelancer needs to start the work
The Excel file you want statistics from
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