Auto copy cell value, color and comments

simplicityq88

New Member
Joined
Mar 21, 2011
Messages
11
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
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

ogo

Board Regular
Joined
Mar 15, 2011
Messages
105
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?
 
Last edited:

simplicityq88

New Member
Joined
Mar 21, 2011
Messages
11
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!
 

simplicityq88

New Member
Joined
Mar 21, 2011
Messages
11
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,970
Messages
5,525,965
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top