Auto copy cell value, color and comments

[simplicityq88]

Dear friends,

I'm glad to be here with all the excel users/lovers/experts. I've being using excel for a long time now, I'm not a pro but I know my way around. Now I've go a task to do, to make automated "replica" of certain cell(s) on the same sheet or on a other new sheet.

So let's say I have A1 color YELLOW and I want it automatically to reflect to cell C1, also I want the value inside it to reflect and the comments if possible.
I'm actually surprised that excel didn't offer a formula that copies the whole data of one cell to an other.

I've searched here for several minutes but couldn't find a topic name similar to mine - but I'm sure that it's been covered, I hope so it has.

Best regards,
Jasmin

 

[ogo]

Try this,

sub Macro1
Sheet1.Activate
Range("A1").select
Selection.copy
'Activate sheet
Sheet2.Activate
Range("C1").Select
Activesheet.paste
End Sub

Is this u really want?

 

[simplicityq88]

ogo,

Thank you for posting that solution. It is what I was looking and I'm glad you've replied.

I was wondering if it can actually say:<table width="64" border="0" cellpadding="0" cellspacing="0"><tr height="20"><td class="xl63" style="height: 15pt; width: 48pt;" width="64" height="20">
</td></tr></table>Sub Macro1()
Range("SOME RANGE").Select
Selection.Copy
Range("SOME RANGE").Select
ActiveSheet.Paste
End Sub

And is there a way to make a macro refresh every 10 seconds or so?

Best regards!

 

[ogo]

I have never tried auto refresh, you can get some info from the link below,
http://www.mrexcel.com/forum/showthread.php?t=298268


For selecting range, You can use for example,

Range("A1:D7").Select
Selection.Copy
Range("E1:H7").Select
ActiveSheet.Paste


Regards,
Ogo

 

[simplicityq88]

EDIT:

Thank you ogo once again, I've managed to do the range, a little bit of logic used hehe and I'll try to find the autorefresh on the link you've gave me.

"Ok, I've made it do for a range, but can it be made to refresh every now and then?"

Best regards,
Jasmin