YOU MUST BE VERY FAMILIAR TO OPEN OFFICE WORKSHEETS (It's bit different than MS Excel).
I have a Master Open Office Spreadsheet. The text and numbers in all sheets in Arabic, but I think anyone can do this task.
1) I need you to create MACROS and VBA code linking various formulas of the Master sheet to data ranges in the 20 + subsheets.
Note: All those sub-sheets can be joined to make one mega FEED-sheet, if you want to do so.
- There are from 1000 to 6000 rows x 20 columns in each subsheet.
2) I need the Master Work Sheet to be fully optimized for quick loading & saving.
3) I want a macro to give ability for all comments in the master sheet to display all at once by clicking a button. Another button for quick update of all dynamic links you will create or manual trigger for recalculation. This auto - links on/off feature is not available as standard in Open Office, and must be done by a macro.
I think few hours up to 1 day is needed for this project. So, my budget is = < $50 CDN. Thanks.