I would like to somewho automate rather tedious process of lookup, merge and format of one of my reporting spread sheets. The manual process in place now (macro to replicate that if possible): - The original has two tabs which are to be merged into one tab with two separate sections on the result - Result file to include only items created / older than 3 days (formula from Create Date column on each tab of original file) - Result file to only “pull in†the relevant info from original (as per column headings in result file); all the redundant data from original can be ignored - Result file to have additional “Days Open†column displaying value of today()-Issue raised (Issue raised = Create Date from original but formatted to AU date format) - Formatting of the result (specifics to be provided) Anyone willing / able to create relevant automation for this? Let me know what other specific details (sample files) you may need and / or pls provide me with a quote and timeline. Appreciate your help, kind regards jkool
Nobody can do this? Its obviously a paid job and dare I say I am willing to pay well for the desired result Thanks jkool
Hi I think i can do this. I have created many macros before for data control in EXCEL. please send me a sample of data with explanation. I will do this for you .will quote the price after reviewing the data. thanks sudha