Prev: Hovering over an object
Next: Search & Replace
From: stevestr on 1 Apr 2010 16:39
I have an employee expense report that contains employee information in the
first five rows. The rows 6 through 30 are blank and for the employee to
fill in (or add additional rows if necessary) with a list of their expenses.

In rows 31 - 37, there is information that the employee acknowledges that
the expenses listed in the rows are true and incurred on behalf of his/her
job duties.

I have a macro that automatically prints this worksheet. If the employee
doesn't have enough expenses to fill all the rows between 6 and 30, I would
like to create a routine in my macro to look for the first blank in row A and
delete the blank rows until the macro finds a text entry in row B - which, if
all rows 6 through 30 have been used, cell 32B begins the text that follows
the expenses that the employee must sign verifying that expenses listed above
are correct and incurred on behalf of his/her job.

Thanks for your help!


From: Don Guillett on 1 Apr 2010 17:28
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"stevestr" <stevestr(a)discussions.microsoft.com> wrote in message
news:9363F33B-4927-428E-B89F-337C20B38270(a)microsoft.com...
>I have an employee expense report that contains employee information in the
> first five rows. The rows 6 through 30 are blank and for the employee to
> fill in (or add additional rows if necessary) with a list of their
> expenses.
>
> In rows 31 - 37, there is information that the employee acknowledges that
> the expenses listed in the rows are true and incurred on behalf of his/her
> job duties.
>
> I have a macro that automatically prints this worksheet. If the employee
> doesn't have enough expenses to fill all the rows between 6 and 30, I
> would
> like to create a routine in my macro to look for the first blank in row A
> and
> delete the blank rows until the macro finds a text entry in row B - which,
> if
> all rows 6 through 30 have been used, cell 32B begins the text that
> follows
> the expenses that the employee must sign verifying that expenses listed
> above
> are correct and incurred on behalf of his/her job.
>
> Thanks for your help!
>
>

 | 
Pages: 1
Prev: Hovering over an object
Next: Search & Replace