En cours

Excel macro - copy cells value to clipboard, depend on cell's color

Hi there,

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.

Example:

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

Regards

Peter

Compétences : Saisie de Données, Traitement de Données, Excel

Voir plus : macro copy pasting pdf excel, macro copy data pdf excel, macro copy data explorer excel, copy cells automatically excel, write script macro copy data website excel, macro copy web content excel, excel macro copy paste form excel, excel macro copy cells spreadsheets, macro copy cells different spreadsheet, excel macro copy cells

Concernant l'employeur :
( 12 commentaires ) Öttevény, Hungary

N° du projet : #8525669

Décerné à :

bossumd

Ready to do the job quickly and neatly. It takes no more then 2 hours to complete your project. MS Office 2003, 2007, 2011 (for MacOS), 2013 compatible.

19 € EUR en 1 jour
(3 Commentaires)
1.4

6 freelance ont fait une offre moyenne de 24 € pour ce travail

naseefo

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.

36 € EUR en 0 jours
(3 Commentaires)
2.9
hectormtnezg

I am very skilled at using Excel with Macros. I can have this requirement delivered in less than 1 hour.

23 € EUR en 1 jour
(0 Commentaires)
0.0
BizProjects2015

A proposal has not yet been provided

30 € EUR en 1 jour
(0 Commentaires)
0.0
Dreams24

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.

22 € EUR en 1 jour
(0 Commentaires)
0.0
imrankawat

A proposal has not yet been provided

16 € EUR en 1 jour
(0 Commentaires)
0.0