Attend Excelapalooza
Thanks Thanks:  0
Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: Opening and Modifying Excel with Access VBA

  1. #21
    New Member
    Join Date
    Apr 2012
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Opening and Modifying Excel with Access VBA

    I hope this explains what I am trying to do.





    Delete ROWS
    My Excel sheet contains a Summary and a Detailed section within the same sheet. I want to delete the Summary section in Red. I was trying to do this by saying find "Provision Date" and then delete all rows above the row that contain "Provision Date"



    Header1 Header2 Header3 Header4 Header5
    5/14/2018 5000 Magic Tv West N/a
    5/14/2018 10000 Magic Tv East N/a
    5/14/2018 2000 Magic Tv South N/a
    5/14/2018 600 Magic Tv North N/a
    5/13/2018 1500 Magic Tv West N/a
    5/13/2018 900 Magic Tv East N/a
    5/13/2018 1260 Magic Tv South N/a
    5/13/2018 15000 Magic Tv North N/a
    5/13/2018 0 Magic Tv West N/a
    SHeader1 SHeader2 SHeader3 SHeader4 SHeader5 SHeader6 SHeader7 SHeader8 SHeader9
    5/14/2018 200 Johnson Pack001 West Incoming Taxable 30 days N
    5/14/2018 300 Smith Pack03 North Referral Taxable 30 days N
    5/14/2018 500 Longbottom Pack03 East Incoming Taxable 30 days N
    5/14/2018 150 Clark Pack001 South Incoming Taxable 30 days N
    5/14/2018 -890 Fox Pack001 West Incoming Notaxable 30 days Y
    5/14/2018 2000 James Pack03 North Incoming Taxable 90 days N
    5/14/2018 500 Black Pack001 North Incoming Taxable 30 days N
    5/14/2018 600 Whilken Pack03 East Referral Taxable 30 days N




    Delete columns after Summary section has been deleted
    Once my header data has been deleted and my detail data has shifted up so that the row that contains "Provision Date" is now in row 1. I need to unmerge my data. Assume SHeader 3 consist of the column C and D and SHeader6 consist of column H and I. What I need to do is unmerge the columns and then delete column D and column I, since both of them are blank.


    SHeader1 SHeader2 SHeader3 SHeader4 SHeader5 SHeader6 SHeader7 SHeader8 SHeader9
    5/14/2018 200 Johnson Pack001 West Incoming Taxable 30 days N
    5/14/2018 300 Smith Pack03 North Referral Taxable 30 days N
    5/14/2018 500 Longbottom Pack03 East Incoming Taxable 30 days N
    5/14/2018 150 Clark Pack001 South Incoming Taxable 30 days N
    5/14/2018 -890 Fox Pack001 West Incoming Notaxable 30 days Y
    5/14/2018 2000 James Pack03 North Incoming Taxable 90 days N
    5/14/2018 500 Black Pack001 North Incoming Taxable 30 days N
    5/14/2018 600 Whilken Pack03 East Referral Taxable 30 days N

  2. #22
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    73,557
    Post Thanks / Like
    Mentioned
    23 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Opening and Modifying Excel with Access VBA

    There are no rows that contain the text 'Provision Date'.
    If posting code please use code tags.

  3. #23
    New Member
    Join Date
    Apr 2012
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Opening and Modifying Excel with Access VBA

    SHeader1 would contain Provision Date. I apologize.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

DMCA.com