+ Reply to Thread
Results 1 to 7 of 7

Macro to Pull in Cell of Data to new sheet

  1. #1
    Registered User
    Join Date
    08-01-2017
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    54

    Macro to Pull in Cell of Data to new sheet

    Hi, I am trying to create a Macro that will allow me to paste data in to the Raw Data tab and have it pull the cell that starts out with an 8 digit number and place them in the Output tab. I will be pulling this data for about 45 days out so there should be a lot more data than the test Raw data I provided.


    Thank you for your Help!
    Attached Files Attached Files
    Last edited by bbeards; 01-16-2018 at 04:08 PM. Reason: Solved

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to Pull in Cell of Data to new sheet

    Try this:
    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

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to Pull in Cell of Data to new sheet

    You're welcome and thanks for the rep!

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Macro to Pull in Cell of Data to new sheet

    @ xladept,

    Stop picking the easy solutions. Lazy you. It is criminal for someone with your skills.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to Pull in Cell of Data to new sheet

    @ Winon - I'm devastated can there be any penance appropriate to this infraction?

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Macro to Pull in Cell of Data to new sheet

    @ xladept,

    Just to have you as a friend is enough, Orrin. Thank you for you!

    Keep the good sense of humor, and thank you for tolerating me.

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to Pull in Cell of Data to new sheet

    @ Winon - Tjaart, tolerating you is a piece of cake - don't stop!

+ 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. [SOLVED] Need Macro to pull data from 1 sheet and filter into another sheet
    By asmithusa in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-15-2014, 04:51 PM
  2. Replies: 19
    Last Post: 05-13-2013, 01:08 PM
  3. Creating a Macro that will automatically pull data from a new spreed sheet.
    By btm88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2013, 05:23 PM
  4. Pull data from a specific sheet that matches cell value on Input Sheet
    By vaciaravino in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-12-2012, 08:38 PM
  5. Macro code to pull the data from different sheets to main sheet
    By Shanthuday in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2012, 09:54 AM
  6. Replies: 1
    Last Post: 11-03-2011, 12:22 PM
  7. Macro - pull data from sheet 1 to sheet 2?
    By Novice_704 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2007, 11:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1