+ Reply to Thread
Results 1 to 10 of 10

Copying specifc information from a specific sheet based on title typed in

  1. 02-18-2019, 02:36 PM #1
    youssefexcel
    youssefexcel is offline
    Registered User
    Join Date
    02-18-2019
    Location
    usa
    MS-Off Ver
    2016
    Posts
    10

    Copying specifc information from a specific sheet based on title typed in

    Hello All,
    First of all thank you all for your expertise. I have always found the answer to my questions throughout this forum but now I have come across a specific situation that I am unable to solve. Your assistance is greatly appreciated.

    What I am attempting to do -

    I am gathering specific data that is in the same spot of each worksheet. To do this, I am doing the following ..

    Starting on the "Data" sheet, an individual will first input the title of the sheet lets say it is within cell B22. In the following code the title is 200541841.
    Once the macro is started -
    1.) A new column is added to allow a place for the data to be placed
    2.) The title (which individual types in) is copied to the top of the column where the data will be placed
    3.) Find function is used to go to the specific page that has the same title using what is placed within B22
    4.) From that sheet there is data from E17 that needs to go back to "Data" sheet in what is now D3 due to inserting a new column
    5.) Then back to 200541841 need to copy W14:W22 to "Data" sheet D5:D13

    So what I am asking from the community is how do I generalize this capturing of the data so that whatever title is typed it, once the macro is ran - it will automatically gather that data.

    Please let me know if I am giving too little information.
    Thank you

    HTML Code: 
    Attached Files Attached Files
    Last edited by youssefexcel; 02-21-2019 at 12:49 PM.
    Reply With QuoteRegister To Reply
  2. 02-18-2019, 03:40 PM #2
    banaanas
    banaanas is offline
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    199

    Re: Copying specifc information from a specific sheet based on title typed in

    You should attach a workbook for reference, would be a lot easier that way
    Tuomas "Banaanas" Savonius
    Trying to give back now when I actually can do some VBA
    Reply With QuoteRegister To Reply
  3. 02-18-2019, 04:30 PM #3
    youssefexcel
    youssefexcel is offline
    Registered User
    Join Date
    02-18-2019
    Location
    usa
    MS-Off Ver
    2016
    Posts
    10

    Re: Copying specifc information from a specific sheet based on title typed in

    Hello! I could not find the feature to upload here so I uploaded it on a different host! upload.cat /b0975c711cd7def2

    Thank you for your time!
    Reply With QuoteRegister To Reply
  4. 02-18-2019, 04:58 PM #4
    AliGW
    AliGW is offline
    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
    80,830

    Re: Copying specifc information from a specific sheet based on title typed in

    Attach your workbook here.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    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.
    Reply With QuoteRegister To Reply
  5. 02-21-2019, 12:50 PM #5
    youssefexcel
    youssefexcel is offline
    Registered User
    Join Date
    02-18-2019
    Location
    usa
    MS-Off Ver
    2016
    Posts
    10

    Re: Copying specifc information from a specific sheet based on title typed in

    Hello Good Sir,

    I have updated the post with an attached workbook!
    Reply With QuoteRegister To Reply
  6. 02-21-2019, 12:53 PM #6
    AliGW
    AliGW is offline
    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
    80,830

    Re: Copying specifc information from a specific sheet based on title typed in

    Good Sir? Do I look like a man? Oh, dear ...

    Thanks for the workbook.
    Reply With QuoteRegister To Reply
  7. 02-21-2019, 02:14 PM #7
    youssefexcel
    youssefexcel is offline
    Registered User
    Join Date
    02-18-2019
    Location
    usa
    MS-Off Ver
    2016
    Posts
    10

    Re: Copying specifc information from a specific sheet based on title typed in

    Quote Originally Posted by AliGW View Post
    Good Sir? Do I look like a man? Oh, dear ...

    Thanks for the workbook.
    Oh no! That was intended for Mr. Banaanas. I clicked "reply" on his comment but I see now that "Reply with quote" is the better option.

    Thank you to you also for explaining how to add an attachment!!!
    Reply With QuoteRegister To Reply
  8. 02-21-2019, 11:47 PM #8
    vcoolio
    vcoolio is offline
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,098

    Re: Copying specifc information from a specific sheet based on title typed in

    Hello Youssefexcel,

    Perhaps the following is all that you need. Assign this code to the button:-

    Please Login or Register  to view this content.
    It may be a better option to create a drop down list of sheet names in B22 of the Data sheet just to minimise typing errors.

    I hope that this helps.

    Cheerio,
    vcoolio.
    Reply With QuoteRegister To Reply
  9. 02-22-2019, 10:04 AM #9
    youssefexcel
    youssefexcel is offline
    Registered User
    Join Date
    02-18-2019
    Location
    usa
    MS-Off Ver
    2016
    Posts
    10

    Re: Copying specifc information from a specific sheet based on title typed in

    Quote Originally Posted by vcoolio View Post
    Hello Youssefexcel,

    Perhaps the following is all that you need. Assign this code to the button:-

    Please Login or Register  to view this content.
    It may be a better option to create a drop down list of sheet names in B22 of the Data sheet just to minimise typing errors.

    I hope that this helps.

    Cheerio,
    vcoolio.
    Hello Vcoolio,

    Your assistance is greatly appreciated - the code works perfectly! I now understand what the best method is to refer to a different worksheet. I have tried adding more code to yours to better understand what is going on but it is giving me a debug error .. I am sure you will see the issue very quickly..

    Thank you again!


    Just as I was about to submit this reply I realized the issue! - by adding a new row it also moved away the worksheet name from B22 down to B23 causing the error! I will work on the drop down list now and will keep you updated on the status. Thank you again for your help!
    Reply With QuoteRegister To Reply
  10. 02-22-2019, 10:13 AM #10
    vcoolio
    vcoolio is offline
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,098

    Re: Copying specifc information from a specific sheet based on title typed in

    Hello Youssefexcel,

    You're welcome and I'm glad to have been able to help you.
    Thanks for the rep also.

    Cheerio,
    vcoolio.
    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. Print specific page on specifc sheet
    By Bugge in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2018, 05:30 PM
  2. Delete entire row when specifc word is typed into a cell in that row
    By d41 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2016, 10:05 AM
  3. [SOLVED] Pulling specific text within a text in which the information is typed differently
    By djmatok in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-02-2014, 06:11 PM
  4. Add information to specific Sheet based on ComboBox selection
    By paralegal91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 04:09 AM
  5. Copying row of information to table on different sheet based off drop down selection
    By mrosenhamer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2013, 04:23 PM
  6. Create summary based on specifc value in a different sheet
    By RayYeung in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-19-2005, 12:39 AM
  7. Coloring Cell based on typed information
    By Jonker19 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2005, 09:50 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