+ Reply to Thread
Results 1 to 8 of 8

Find first non-blank cell after a group of blanks copy offset cells, find next blank, loop

  1. #1
    Registered User
    Join Date
    07-08-2012
    Location
    Melbourne Australia
    MS-Off Ver
    Excel 2003
    Posts
    79

    Find first non-blank cell after a group of blanks copy offset cells, find next blank, loop

    Hello

    I’ve been a longtime lurker around these parts first post.

    I was hoping to make this an add-ins so eventually when I receive this email every day I could just click the button.

    Had a great search, got some ideas but never an exact match

    I'm self-taught from forums so struggle but have some basics

    An extract of the email I get each day is attached

    Extract.xls

    The final product is in CA History (this is saved on our server)

    I manually find the highlighted rows and copy and paste the information from "C" “F” “I” “K” “T” “V” “X” into the other sheet it can reach 5000+ lines

    The first 5 rows never change and what I was hoping was to first Select C6

    Then create this
    Find first non-blank cell in column “C” (or the first cell that contains the account number which is 5 numbers)
    Copy this value
    Copy offset values in “F” “I” “K” “T” “V” “X”
    Paste in CA History
    Then find the next blank
    – repeat

    Thoughts if this would be the best method?

    Has anybody attempted this recently and could give me an example?

    Or better still would somebody help me please?

    Thanks Glenn

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Find first non-blank cell after a group of blanks copy offset cells, find next blank,

    Try this
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-08-2012
    Location
    Melbourne Australia
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: Find first non-blank cell after a group of blanks copy offset cells, find next blank,

    Great reply thankyou

    reped

  4. #4
    Registered User
    Join Date
    07-08-2012
    Location
    Melbourne Australia
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: Find first non-blank cell after a group of blanks copy offset cells, find next blank,

    Darn i thought i was good enough to change this code to copy the information to another workbook... but i failed!

    any thoughts please?

    desired location of my workbook is ("C:\Users\glsam\Documents\1209 Corporate Action History actioned.xlsx")
    desired location worksheet is "archive"

    Please Login or Register  to view this content.
    Last edited by gwsampso; 10-21-2012 at 02:05 AM. Reason: update code

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Find first non-blank cell after a group of blanks copy offset cells, find next blank,

    What is
    Please Login or Register  to view this content.
    ?
    Please Login or Register  to view this content.
    ?

  6. #6
    Registered User
    Join Date
    07-08-2012
    Location
    Melbourne Australia
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: Find first non-blank cell after a group of blanks copy offset cells, find next blank,

    oh sorry

    1209 Corporate Action History actioned.xlsx

    nice pick up on that little change

    i'll try now

  7. #7
    Registered User
    Join Date
    07-08-2012
    Location
    Melbourne Australia
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: Find first non-blank cell after a group of blanks copy offset cells, find next blank,

    excellent find! thanks again cant beleive i missed that.

    how do you reckon i should go about in future leaving one coloumn like "B" blank?

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Find first non-blank cell after a group of blanks copy offset cells, find next blank,

    Quote Originally Posted by gwsampso View Post
    how do you reckon i should go about in future leaving one coloumn like "B" blank?
    Why do you think so?

    I don't recommend to include any blank column(s)/row(s) within the data area.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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