Until reading a Excel and VBA for dummies I didn't think my next request was possible. However, it looks like almost anything is possible with Excel
I was wondering if someone could show me how to go about having Excel automatically A) sort a column by colour B) copy the selection and place the copied selection in a specified worksheet.
Let me explain.
You'll see from the attached workbook there are five worksheets. Each worksheet has a number of row. Some of the rows have been highlighted in column A3 for each sheet.
At the moment, I sorting the rows by colour and then copying the symbols with the highlights in column B and placing those symbols in the appropriate column in sheet MFI Green Scan Template.
If you look at sheet 'Four Lows Five Highv2' I've sorted the rows by colour then copied the symbols and pasted them in 'MFI Green Scan Template'.
I would like Excel to automate that procedure.
Can someone please tell me if it is actually possible and show me how to do it?