+ Reply to Thread
Results 1 to 10 of 10

Auto duplicate changes made in one column of one worksheet to another worksheet

  1. #1
    Registered User
    Join Date
    09-07-2013
    Location
    Las Vegas,NV
    MS-Off Ver
    Excel 2000
    Posts
    5

    Auto duplicate changes made in one column of one worksheet to another worksheet

    I have a spreadsheet that has 2 worksheets. The first has a list of items in column A5 -A135 and sheet two lists expenses for those items. I would like to have what ever changes ( format, color fill, adding additional rows, etc) be automatically duplicated to column A5-A135 etc on worksheet 2.
    The column is divided into section categories with description headers at each section so occasionally I need to add a row inside a section category when I run out of space.
    Any help would be greatly appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Auto duplicate changes made in one column of one worksheet to another worksheet

    Can you please attach a copy of your spreadsheet in xls or xlsx format.
    Please remove or change any sensitive information.

    Regards

    peterrc

  3. #3
    Registered User
    Join Date
    09-07-2013
    Location
    Las Vegas,NV
    MS-Off Ver
    Excel 2000
    Posts
    5

    Re: Auto duplicate changes made in one column of one worksheet to another worksheet

    Thank you for your response. I am sending a sample test workbook for you to see. I hope you understand what I need. Please feel free to ask questions.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Auto duplicate changes made in one column of one worksheet to another worksheet

    Please see attached.
    It may not be exactly what you are looking for but it is a "workaround" that I have used many times.
    On the Items Sheet in cell A4 click Items for Items and Cost for cost (everything is now on the same sheet and some cells are linked).
    Let me know if it is of any use to you.

    Regards

    peterrc
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-07-2013
    Location
    Las Vegas,NV
    MS-Off Ver
    Excel 2000
    Posts
    5

    Re: Auto duplicate changes made in one column of one worksheet to another worksheet

    Thank you very much. I like this. Now how do I input this into my current workbook?

  6. #6
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Auto duplicate changes made in one column of one worksheet to another worksheet

    I have attached another copy of my workbook but have added to the Cost Sheet a "step by step guide" which hopefully you will be able to follow.
    Any problems or queries let me know.

    Regards

    peterrc
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    09-07-2013
    Location
    Las Vegas,NV
    MS-Off Ver
    Excel 2000
    Posts
    5

    Re: Auto duplicate changes made in one column of one worksheet to another worksheet

    Thank you very much. I new I came to the right place with this problem. You guys are awesome!

  8. #8
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Auto duplicate changes made in one column of one worksheet to another worksheet

    lektrikwiz

    Welcome to the forum.

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  9. #9
    Registered User
    Join Date
    09-07-2013
    Location
    Las Vegas,NV
    MS-Off Ver
    Excel 2000
    Posts
    5

    Re: Auto duplicate changes made in one column of one worksheet to another worksheet

    Thank you for the update. Still new to the forum.

  10. #10
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Auto duplicate changes made in one column of one worksheet to another worksheet

    No worries! That's why we are here. To showing the correct way! Thanks for the understanding.


    Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Incrementing Column's value +1 each time a change is made in another worksheet
    By SuGo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2013, 12:16 PM
  2. Replies: 1
    Last Post: 04-19-2013, 07:49 AM
  3. Replies: 2
    Last Post: 04-02-2013, 04:43 PM
  4. Replies: 9
    Last Post: 09-10-2012, 01:35 PM
  5. Replies: 10
    Last Post: 10-07-2011, 03:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1