Hi there,

I please desperately need a solution to this problem that I am having with
an Excel Formula.

Let me explain how this is supposed to work:

I have one workbook which i use my my main timesheet then i have 30+ other
workbooks which are individual client timesheets. i have

added in the following function for each client timesheet to gather
specific info from the main timesheet workbook in column F:

=IF('[MAIN TIMESHEET.xls]October'!$F4="BWC",'[MAIN
TIMESHEET.xls]October'!$B4:$I4,"")

So, what this does is that if in the specific client timesheet, in column F,
the letters BWC appear, then it must take the info

from that entire row on the main timesheet workbook and insert that row of
info into the client timesheet workbook. Now here's my

problem, if the info on the main timesheet workbook is in row 6, then on the
client timesheet workbook, that info is also inserted

into row 6 and not on the first row that is blank.

I am now looking for a macro that i can add in that will be able to delete
these blank rows, even if they have a formula in them

already. Do you have any advice on the best way to proceed from here?
--
Sincerely,

Sarcalogus