+ Reply to Thread
Results 1 to 5 of 5

copy contents to another sheet without inserting formula in destination cell

  1. 02-13-2014, 01:38 PM #1
    rexer231 is offline
    Registered User
    Join Date
    05-01-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    39

    copy contents to another sheet without inserting formula in destination cell

    I have two sheets - sheet1 and sheet2,


    ColumnA of sheet2 has a formula to calculate some values. I want the result to show in column A of sheet1 without placing a formula in ColumnA of sheet1..



    for example


    sheet2

    columnA

    cell - A3 contains -> =if(b2>0,"True","False")

    i want the contents of sheet2, A3 to be displayed in Sheet1, A3 ( without putting a formula in sheet1A3). so no vlookup forumlas.

    this is because in case i delete a row or add a row, the formulas will get messed. hence want to know how to achieve this.
    Reply With QuoteRegister To Reply
  2. 02-13-2014, 06:19 PM #2
    Pauleyb is offline
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: copy contents to another sheet without inserting formula in destination cell

    So, you just want the values to be copied? Use Copy->Paste Values.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
    Reply With QuoteRegister To Reply
  3. 02-14-2014, 12:30 AM #3
    rexer231 is offline
    Registered User
    Join Date
    05-01-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: copy contents to another sheet without inserting formula in destination cell

    There is too much data and the values keep changing...copy pasting is creating too much manual effort too frequently..
    Please help in automation
    Reply With QuoteRegister To Reply
  4. 02-14-2014, 11:12 AM #4
    Pauleyb is offline
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: copy contents to another sheet without inserting formula in destination cell

    I think I understand now. You threw me off with your statement of "without placing a formula" to be saying you don't want a formula at all.

    Wow - and to think I probably had a solution, but since you ding'ed me as 'not a value add' when I was trying to understand, I'll just keep my value to myself.
    Last edited by Pauleyb; 02-14-2014 at 12:01 PM.
    Reply With QuoteRegister To Reply
  5. 02-14-2014, 01:56 PM #5
    rexer231 is offline
    Registered User
    Join Date
    05-01-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: copy contents to another sheet without inserting formula in destination cell

    Well, since i can ding you, i can also unding u.. xxxxxxx, xxxxxx xxx xxxx xxxxx xxx xxxxxx.. would not be asking for a solution that is manual copy paste..
    was asking for assistance. if provided, would be thankful.

    Moderators note: Please refrain from insulting other members. If you have nothing good to say - say nothing
    Last edited by FDibbins; 02-14-2014 at 02:20 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inserting contents of a cell into a formula
    By woutervan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-10-2013, 09:14 AM
  2. Using destination filepaths listed in cell contents opposing to coding destination
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2009, 01:23 PM
  3. Formula Help- Inserting characters around cell contents
    By dbforum29 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-24-2007, 02:00 PM
  4. [SOLVED] Replaceing destination cell contents with new data in Excell
    By Duane L Kibby in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-17-2005, 02:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1