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
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,017
Messages
5,834,960
Members
430,330
Latest member
drAli77

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top