i have a 13 x 13 matrix in Excel. All cell has a color. I would like to select a cell and push a button, what copies the all the cell's coordinates to the clipboard where the color matches. With a separator character. But only that colored cells.
A1, A11, B1 cells are red, all other are blue. If i select the B1 cell and push the button, then the clipboard would be 0,0; 0,10; 0,1
Because A1 cell's coordinates are 0,0
A11 => 0:10
B1 => 1:0
5 freelance font une offre moyenne de €25 pour ce travail
Hi there! I am expert in MS Excel with advanced VBA functionalities. I can do this job for you with a quick turnaround time. Looking forward to hear from you. Thank you. Warm regards, Naseef U.
I am very skilled at using Excel with Macros. I can have this requirement delivered in less than 1 hour.
More than 6 yrs of experience in Excel and VBA projects. Developed various kind of excel project consist of Data Entry, Dashboard Design, VBA automation, Web scrapper tool, Addins etc.