+ Reply to Thread
Results 1 to 26 of 26

Finding a column in one sheet and pasting in another sheet- ones I found dont work

  1. 06-01-2015, 07:59 PM #1
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Exclamation Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Hi Everyone,
    I hope to get a reply soon this is my first time on here although I have been here for a while, sorry.

    My goal is to find a column header name "Current" which could be ANYWHERE in a worksheet (worksheet name-- >"00-1820080") and paste it to another sheet (worksheet name ---> "Upload") on column I.
    I have the following formulas but they failed to solve my problem, they keep posting Column I from (worksheet name-- >"00-1820080") to Column I on (worksheet name ---> "Upload") ... I don't want that:

    Please Login or Register  to view this content.

    AND I have tried this following formula as well .. bother don't work .. first one was working fine for a while and not it doesn't work :S

    Please Login or Register  to view this content.
    Last edited by FDibbins; 06-04-2015 at 06:15 PM.
    Reply With QuoteRegister To Reply
  2. 06-02-2015, 09:39 AM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 06-02-2015, 10:27 AM #3
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Good Morning John,

    Thank you so much for your reply, I just tried the formula and it still doesn't seem to work... it seems to skip over that code.
    I can attach the file..
    the form tab has the button to run the macro. and that code is located in the "createupload" module it is located in the top after the "headings"
    ... well not im trying to attach the file and its not letting me attach it, keeps loading.
    Reply With QuoteRegister To Reply
  4. 06-02-2015, 10:58 AM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Can you attach a sample with some dummy data. To attach a file click on Go Advanced, scroll down to the Manage Attachments button, browse to the required file, and then push the Upload button then hit done.
    Reply With QuoteRegister To Reply
  5. 06-02-2015, 01:12 PM #5
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    I tried that and since then it is still "uploading" and nothing is being uploaded.
    Reply With QuoteRegister To Reply
  6. 06-02-2015, 01:21 PM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    You don't have too upload your original file. The size may be too large. Just create a sample with a little data, enough to show what the problem is. Then we can take a look at it.
    Reply With QuoteRegister To Reply
  7. 06-02-2015, 01:32 PM #7
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Trying a 600kb file now and its still "uploading"
    Reply With QuoteRegister To Reply
  8. 06-02-2015, 06:52 PM #8
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Can anyone help?
    Reply With QuoteRegister To Reply
  9. 06-04-2015, 05:58 PM #9
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Reduce your sample workbook to just what you need to show what you have, and what you want. Remove anything that does not directly relate to your question, then try the upload again
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  10. 06-04-2015, 06:12 PM #10
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    I have done that over and over again to the point where my workbook was 600kb and it still didn't work.

    I can paste all my code below... 
    Please Login or Register  to view this content.
    Last edited by FDibbins; 06-04-2015 at 06:14 PM.
    Reply With QuoteRegister To Reply
  11. 06-04-2015, 06:14 PM #11
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    You need to use code tags when posting code, see point 1 of my signature.

    I will add them for you - this time

    edit: OK, I see that you did try to use code tags, you didnt close them
    Reply With QuoteRegister To Reply
  12. 06-04-2015, 06:14 PM #12
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    here is the code for newother_

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  13. 06-04-2015, 06:16 PM #13
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    The / goes before the CODE, not after
    Reply With QuoteRegister To Reply
  14. 06-04-2015, 06:17 PM #14
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Oh I see! Ill be keen to do that next time...
    Reply With QuoteRegister To Reply
  15. 06-04-2015, 06:26 PM #15
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    So whats happening is that im trying to find a column with the heading "current" which could be anywhere on sheet 00-1820080 and paste it on column "I" on sheet "Upload"...
    instead of doing that the code picks up column I and posts to column on the other sheet.
    Reply With QuoteRegister To Reply
  16. 06-04-2015, 06:59 PM #16
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Hi Ali,

    Try John's program with this adjustment:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  17. 06-04-2015, 07:23 PM #17
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    I will definitely try and let you know, just left work... thank you so much!
    Reply With QuoteRegister To Reply
  18. 06-04-2015, 07:34 PM #18
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    You're welcome - hope it works
    Reply With QuoteRegister To Reply
  19. 06-05-2015, 10:28 AM #19
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    That didn't work either, the whole formula was ignored. so weird! I mean this isn't the most technical thing. I wish I could email the file since its not uploading.
    Reply With QuoteRegister To Reply
  20. 06-05-2015, 01:48 PM #20
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Hi Ali,

    Try this - it will search the first 5 rows:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  21. 06-05-2015, 01:59 PM #21
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    It works! :D
    Thank you so so so much!
    Been trying to figure this our for several days now!
    I appreciate the help from you guys!
    Reply With QuoteRegister To Reply
  22. 06-05-2015, 03:45 PM #22
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    You're welcome and thanks for the rep!

    *Your header probably had trailing space(s).
    Reply With QuoteRegister To Reply
  23. 06-05-2015, 03:51 PM #23
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    It works! :D
    Thank you so so so much!
    Been trying to figure this our for several days now!
    I appreciate the help from you guys!
    Reply With QuoteRegister To Reply
  24. 06-05-2015, 03:52 PM #24
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    sorry It sent the same message twice.. what did you mean by "trailing spaces"?
    Reply With QuoteRegister To Reply
  25. 06-05-2015, 04:09 PM #25
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Finding a column in one sheet and pasting in another sheet- ones I found dont work

    Hi Ali,

    Instead of the header reading "Current" it probably reads "Current " and as such wouldn't be seen as a match.
    Reply With QuoteRegister To Reply
  26. 06-05-2015, 04:12 PM #26
    alirizvi1
    alirizvi1 is offline
    Registered User
    Join Date
    12-20-2013
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    18
    Quote Originally Posted by xladept View Post
    Hi Ali,

    Instead of the header reading "Current" it probably reads "Current " and as such wouldn't be seen as a match.
    Oh, I see! That could very well be it! Thanks so much!
    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. [SOLVED] Copy row from one sheet and paste to another if a key word is found in 1 column of sheet 1
    By killdozer in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-17-2014, 02:27 PM
  2. Macro for finding cell value and pasting entire column in new sheet
    By rexer231 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2013, 07:20 AM
  3. need macro to compare column in one sheet to another sheet and if part # is not found copy
    By naunid in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-20-2013, 09:40 AM
  4. VBA Codes dont work when sheet is protected
    By SARC777 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-18-2010, 10:32 AM
  5. when I protect my sheet enter tab, & arrow keys dont work...
    By greg in forum Excel General
    Replies: 0
    Last Post: 05-25-2005, 11:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1