×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

(OP)
Like in title. I have MAIN sheet and I need to to copy most of the data to the other one, so when I change something in main, the others sheets are immediately updated.


How to achieve this? The:

=$DEFAULT-SHEET.$C$100

is NOT working for comments, conditions, text color, etc.

RE: Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

Are you talking about Excel Camera Tool ponder

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

RE: Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

(OP)
Hi, nope. I'm talking about simple office excel sheet.

Lets suppose we have 3 sheets:
MAIN | OTHER1 | OTHER2

I have data in main that is copied to other sheets. BUT there are not copied with comments, conditions, text color, backgroud color, etc. When I change the specific field color text for example, I need to have this change visible in other sheets. But with command:
=$MAIN.$C$100
only the value is changed.

RE: Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

That's because

=$MAIN.$C$100

isn't copying a cell. It is a function that returns a value from a cell

Instead you need a macro or VBA code similar to the following:

CODE -->

    Application.CutCopyMode = False
    Range("A1").Copy ' Source
    Range("B1").PasteSpecial xlPasteAll, xlPasteSpecialOperationNone ' Destination
    Application.CutCopyMode = False 

RE: Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

(OP)
ehhh I don't want to use VBA. I better do that in html/css/d3.js

I thought there is just an simple option to copy ALL (underline, background, conditions, etc.) field data or SOME (like value only).

Thanks!

RE: Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

You may want to investigate the Copy / Paste Special



You have different options there, hopefully you'll find what you're looking for....

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

RE: Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

@spamator12,

As strongm explicitly stated that what you thought was COPY s not COPY.

But this has seemed to go in one ear, so to speak, and out of the other when you replied...

Quote:

I thought there is just an simple option to copy ALL (underline, background, conditions, etc.) field data or SOME (like value only).

And the answer to that statement in isolation is, "YES, that's what COPY does.

HOWEVER, what YOU thought was COPY is not COPY but a formula data assignment. Formulas do not COPY anything!

So lets use the proper terminology so we can all understand what you really want to do.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

RE: Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

Lots of folks ASSUME a solution and then ask here at Tek Tips how to do the thing that they ASSUME. Too often, those ASSUMPTIONS are inirrect!

So how about telling us WHAT has to be done and WHY it needs to be done and describe the sheet. Is it a table or a chart or a list or what.

Then we can suggest one or more way to accomplish the task. Depending on the structure, it may be as simple as a refreshable query, selecting some or all fields.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

RE: Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

(OP)
I guess "=$DEFAULT-SHEET.$C$100" at first post describe everything well. Copy/duplicate/correlation/synergy/adjusting/dependency what ever you call it (english is not my main) at this specific program... @SkipVought it was properly described, just read it again, ass smacking around is not helping.

Anyway, I already did everything in node (I'm doing excel things only few times a year, so adding VBA was not my priority ATM - @strongm , thanks man!), so If somebody put an answer, it will be for other users, that want to relate in a same way (with comments, conditions, text color, etc.) so then you change some fields in MAIN sheet and it is automatically adjusted (in a SAME WAY) in others sheets (you can choose what field to mutate manually).

RE: Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

It is not a problem to copy the contents of some cells to another place, with contents, formulas, comments, but still there may be some issues with names, merged cells, formulas.
However, it looks like you need to have formats and comments dynamic in the other sheet. If so, it requires either manual copy/paste special action after each change, or automation with VBA, or, finally, redesigning the data and simplifying processing.
As Skip stated, 'we can suggest one or more way to accomplish the task' but this requires to be open for other solutions, no direct way to have the same dynamic contents in two places in excel.

combo

RE: Office excel - how to copy field with comments, conditions, background etc. to another sheet ?

(OP)
@combo y I know, @strongm give proper VBA code, but I don't have time to practice it. Node.js was fast and good choice, cause I can compare different calculations and after few code additions, other dev can too (via redis and socket.io). Dynamic content is a nice name for the "thing" ("copy") I wanted to achieve.

Thanks for all of you for help.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close