+ Reply to Thread
Results 1 to 8 of 8

Selecting all data

  1. 11-28-2022, 04:54 PM #1
    RebeccaMorgan
    RebeccaMorgan is offline
    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
    Reply With QuoteRegister To Reply
  2. 11-28-2022, 08:53 PM #2
    beyond Excel
    beyond Excel is offline
    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.
    Reply With QuoteRegister To Reply
  3. 11-28-2022, 08:58 PM #3
    beyond Excel
    beyond Excel is offline
    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?...
    Reply With QuoteRegister To Reply
  4. 11-28-2022, 09:08 PM #4
    TMS
    TMS is online now
    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
    47,128

    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

    Reply With QuoteRegister To Reply
  5. 11-28-2022, 09:12 PM #5
    TMS
    TMS is online now
    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
    47,128

    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.
    Reply With QuoteRegister To Reply
  6. 11-28-2022, 09:24 PM #6
    TMS
    TMS is online now
    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
    47,128

    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.
    Reply With QuoteRegister To Reply
  7. 11-28-2022, 09:25 PM #7
    beyond Excel
    beyond Excel is offline
    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.
    Reply With QuoteRegister To Reply
  8. 12-02-2022, 01:13 PM #8
    RebeccaMorgan
    RebeccaMorgan is offline
    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 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. 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. Selecting row of filtered data, pasting it, then moving down and selecting the next row
    By SamPPG in forum Excel Programming / VBA / Macros
    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. Selecting data from a drop down list in Excel 2010 Data Validation
    By SydB in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1