+ Reply to Thread
Results 1 to 8 of 8

Selecting all data

  1. #1
    Registered User
    Join Date
    11-08-2022
    Location
    Davenport, IA
    MS-Off Ver
    MS 360
    Posts
    15

    Selecting all data

    Attached is a workbook that contains 3 macro's, they all generally work. However when setting up the tables it does not include all of the desired data. I'm trying to learn where to put xlDown and xlRight with selection and make them work within formulas if need be.

    Within the workbook, sheet 1 contains the data to be manipulated. Then you run macro "breakoutdata" first, you'll notice that the table does not encompass all listed data (EFT tab) as well as containing too much (Payment Tab). Then run pivottable macro, that seems to be working well and would be better when the original data is selected correctly. Followed by "delete", which deletes all.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

    Re: Selecting all data

    Hello Rebecca. I suggest you replace the procedure you have with this one:

    Please Login or Register  to view this content.
    You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.

  3. #3
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

    Re: Selecting all data

    .
    And forget to note that the information on Sheet1 must be in the form of a normal range and not a listObject, okay?...

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Selecting all data

    Or keep your source data as is and replace your breakout code with this:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Selecting all data

    The "excess data" in the Payment sheet is because you have blank rows in your source data on Sheet1. I suggest you delete them or adjust the filter to ignore them.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Selecting all data

    Oops. Needed tochange the Table names. I have adjusted the filter for the Payment sheet. Your Pivot Tables can be refreshed.

    Please Login or Register  to view this content.

  7. #7
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

    Re: Selecting all data

    Quote Originally Posted by beyond Excel View Post
    And forget to note that the information on Sheet1 must be in the form of a normal range and not a listObject, okay?...
    My last suggestion comes from the fact that I was studying your original code and noticed that the data on Sheet1 is in the normal range and then the old procedure passes it to listObject.

    So I reiterate: do not complicate yourself and leave that data in the original way.

  8. #8
    Registered User
    Join Date
    11-08-2022
    Location
    Davenport, IA
    MS-Off Ver
    MS 360
    Posts
    15

    Re: Selecting all data

    Thank you guys! I will be giving these a try!!

+ 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. Selecting median data points for integral values in a long raw data
    By agrwl.anmol in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-23-2019, 08:17 AM
  2. Replies: 4
    Last Post: 01-28-2016, 11:13 AM
  3. Selecting a dynamic range of data based off column data
    By wizeone in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-28-2014, 10:44 PM
  4. [SOLVED] Selecting all data in specific columns without selecting adjacent column.
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2014, 02:20 AM
  5. Selecting all data in specific columns without selecting adjacent column.
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2014, 03:50 PM
  6. Replies: 2
    Last Post: 08-01-2013, 07:36 AM
  7. Selecting and Copying Variable Data Range from a Filtered Data Set
    By evan.sams in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2012, 12:02 AM

Tags for this Thread

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