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 : copy cells automatically excel, 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