Closed Thread
Results 1 to 2 of 2

VBA code to copy cell value and paste in different sheet

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    96

    VBA code to copy cell value and paste in different sheet

    Need worksheet_change VBA code .... whenever i write "Print" in column P of everysheet except worksheet " Slips" , the respective value of column B is copied and displayed in B16 column of worksheet "Slips".
    e.g like this

    if targer.column = 16
    if target.value = "Print" then
    ...........................................

    Keep in mind if already value written in B16 of worksheet "Slips" then it should be deleted first then paste the respective value.

    Need code whenever i pick "Print" from dropdown list of column P in worksheets , it copy respectivr value of Column B in Worksheet "Slips" cell B16.
    eg
    if i pick Print in p6 cell from worksheet instrument then value in B16 of worksheet "Slips" deleted and pasted the value of B6 cell of worksheet "Instrument" . and so on
    if i pick Print in p13 cell from worksheet Automation then value in B16 of worksheet "Slips" deleted and pasted the value of B13 cell of worksheet "Automation" and so on
    Thanks
    Need code in Worksheet_Change
    Attached Files Attached Files

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

    Re: VBA code to copy cell value and paste in different sheet

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    You have duplicated this thread 3-4 times. Please refrain from doing so. If repeated, you are likely to be banned.

    Thread Closed.
    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]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VB code to filter copy and paste in a different sheet
    By rshnkmr39 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2013, 12:53 AM
  2. Replies: 1
    Last Post: 03-28-2013, 02:49 PM
  3. Sheet code to copy & paste a new row of Info to another sheet
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 05:31 PM
  4. how to fix code to copy and paste on to next sheet (2007)
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2012, 01:23 PM
  5. Add sheet. Copy Code & Paste in new Module
    By omnibuster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2008, 03:37 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