+ Reply to Thread
Results 1 to 4 of 4

Really new: Copy additions/updates to cell contents into second workbook

  1. #1
    Registered User
    Join Date
    02-01-2012
    Location
    Spokane, WA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Really new: Copy additions/updates to cell contents into second workbook

    See attached file. I want "Description of Piece" (col D) and three other columns in the "MainSupplies" workbook to automatically copy into the corresponding columns in the "SpecificPiece#" workbook so I don't have to enter everything twice. This seems like a simple operation, but I've researched it, played with it, can't seem to make it work.

    In "MainSupplies" I also want to auto-calculate K/I and insert the answer into column L. That's simple too; but how do I tell Excel to do this calculation over a range (every row in columns K and I)? And then to insert the results into a range (every cell in column L)?

    Sorry if this is really basic stuff. I'm new to Excel formulas, have read and experimented without success. Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Really new: Copy additions/updates to cell contents into second workbook

    Why do you need the two sheets?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Really new: Copy additions/updates to cell contents into second workbook

    I have the same question as Roy...what is the purpose of duplicating the data in 2 sheets?

    Regarding your formula, you can put this in L2 and drag it down to how many ever rows you need. Use this formula -
    Please Login or Register  to view this content.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Registered User
    Join Date
    02-01-2012
    Location
    Spokane, WA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Really new: Copy additions/updates to cell contents into second workbook

    Quote Originally Posted by arlu1201 View Post
    I have the same question as Roy...what is the purpose of duplicating the data in 2 sheets?

    Regarding your formula, you can put this in L2 and drag it down to how many ever rows you need. Use this formula -
    Please Login or Register  to view this content.
    Thanks folks. I played with it and came up with =IF(K14<>0,K14/I14,"") which seems to have the desired effect. Excel: Not Like SQL. I am not the only one who will be using these sheets; I don't need the two sheets, but the other person is even less an Excel expert than I am and I'm trying to make it really easy to do what needs to be done.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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