+ Reply to Thread
Results 1 to 6 of 6

Search your Grey matter for past threads

  1. #1
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Search your Grey matter for past threads

    Good afternoon all.

    FIRSTLY I AM NOT ASKING ANYONE TO LOOK AT MY THREAD.

    PLEASE DO NOT BREAK ANY RULES ON MY BEHALF..


    What I would like to ask is, anyone on EF ever came across a VBA thread where they needed help to look
    at cells on Sheet(1) then lookup for a location on Sheet(2) then paste the data in the correct cells.

    If so can you point me to that achieve so I can look it up and get some ideas.

    I have looked at the rules and cannot find a objection to this request.

    Same message posted on OZGRID


    Regards Peter
    One I have learnt over the last few months, " You are NEVER too old to learn ".
    Sometimes I forget to say " Thank You " for your assistance, so here I say " A BIG Thank You. "

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Search your Grey matter for past threads

    Hi Potholes,

    I think you are asking for help learning VBA. When you are dealing with 2 different sheets then you might find code using "With Ws1" or a "Set ws1". If the correct row to paste the data onto is a variable then you might search for "xlUp" in some code. I've done a search for "xlUp" and find this site might be of help.

    https://www.excelforum.com/excel-pro...rrent-row.html

    Better yet would be to search the WWW looking for code examples. I really like CPearson's site and also like to read John Walkenbach's books.

    VBA can be learned by recording a macro and trying to see what your keystrokes turned into, in VBA language. Then you modify the recorded macro to make it more efficient or more useful by finding the LastRow.
    In my VBA code, I've posted on this site, I always use "Dim LastRow as Double" and "Dim RowCtr as Double". Perhaps you can find my vba code by searching for these strings.

    Do you have a specific VBA code problem. I kind of remember you wanted to copy stuff from one sheet to another? You got slapped for cross posting? But we are here to help if you really want some. We had a guy in LA (Los Angeles) who has about 3000 vba questions. He is getting good at thread titles and giving us sample workbooks and we code for him.... I wish he wanted to learn as much as you do.

    Marv
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Search your Grey matter for past threads

    Thank You Marv

    Yes I am doing my darndest to learn.

    P

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: Search your Grey matter for past threads

    Google search: "vba copy cell contents another worksheet"

    First result: https://analysistabs.com/excel-vba/c...et-to-another/

    Code suggested on that page:

    Please Login or Register  to view this content.
    I suggested Googling for things like this many days ago - my advice was clearly ignored. I suspect you will completely ignore Marvin's kind advice, too, and in a week or so it will be Groundhog Day once again.

    I also suggested that you start to make a scrapbook of useful code snippets and try to join them together in a test workbook. You said you'd give it a go, but I don't believe you have because you haven't come to us with any queries about the things you've tried and how to make them work together. Honestly, Pete, I don't really believe that you are doing your damndest to learn, and splashing the cash on books and online courses isn't going to make you any more motivated to do so. There just isn't enough time between your posts for you to have made any effort to learn, and your cross-posting has only highlighted your impatience. My belief is that deep down you are hoping that somebody here will cave in and do it all for you, and I am afraid that to me, this thread reads as if you just want us to do the searching for you. This is based on prior knowledge of your MO and your protestations that you are not asking for this or that (which of course you are, really - think of the lady in Hamlet).

    If you do NOT really want to learn (and I do not really, truly believe that you do), then use your money wisely: buy some credits and post in the commercial services section. You might find someone willing to take the project on and complete it for you, but you will need to be able to articulate CLEARLY what you want.
    Last edited by AliGW; 08-26-2019 at 02:35 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Search your Grey matter for past threads

    Hi Ali

    Far from the truth I have taken on the
    HTML Code: 
    Course and working my way through it.

    I did do a google however my search was maybe to big group of words These are what I did (how to pull values from another worksheet excel).

    It responded with a lot of Vlookups.

    P

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: Search your Grey matter for past threads

    It responded with a lot of Vlookups.
    You missed the crucial VBA from the search terms.

    Far from the truth I have taken on the
    HTML Code:
    https://www.homeandlearn.org/index.html
    Course and working my way through it.
    Please see my edits to the post above. If you want to learn, you need to give it more time. You don't seem to have the patience for it.
    Last edited by AliGW; 08-26-2019 at 03:01 AM.

+ 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. Replies: 11
    Last Post: 02-27-2017, 08:02 AM
  2. partialy search text from list and then past in same worksheet
    By mirza5313 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2016, 10:29 AM
  3. Replies: 1
    Last Post: 09-16-2014, 10:28 AM
  4. how can i search all threads that posted by myself
    By andrewyang in forum The Water Cooler
    Replies: 3
    Last Post: 11-17-2010, 05:43 AM
  5. Why cannot I search threads older than 11.09.2006
    By adnan buran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2006, 06:13 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