Please read whole problem before applying. I also need this done by the end of today please so don't apply if you can't do that.
I need someone to write me two excel VBA macros. One is to export the data from a range on an individual sheet to a csv file. The other macro is to combine ranges from multiple tabs and paste it to a csv file.
First macro -Copy defined range (for example AD:BF or column 30-58 if that's easier) excluding any row where the first column (AD in this example) is blank (or "" with formulas). -Paste values into new csv file -sort by column A in new csv file (ascending) -delete column A -save as csv file in defined location with sheet name, date and timestamp as the file name.
2nd Macro (similar to above but combining multiple ranges into one csv file) -copy defined range on multiple sheets (for example, AM:BO on the OCS tab, ) down to last active row, excluding rows where the first column is blank (or "" through formulas) -paste to new csv -repeat for other defined tabs (for example, then AD:BF on ALPG tab). There could be up to 100 different ranges so I just need the code to allow me to add more manually. -then sort by column A -delete column A - also delete extra headings so that name, rd 1, rd 2 etc is only in row 1 - save as csv file in defined location with workbook name, date and timestamp as the file name
Have attached files as examples... -SUMMARY.xlsm is the source (can't upload for some reason so can download from here (https://drive.google.com/file/d/1a1JTl9N_DtbqhpbljaF93kNO2hs91wms/) -OCS_2020_06_22_12_29.csv is an example of an export I would like from the 1st macro -SUMMARY_2020_06_22_12_29.csv is an example of an export I would like from the 2nd macro.