I PLEASE NEED URGENT HELP WITH A FORMULA!!!

[Sarcalogus]

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?

 

[Roger Govier]

Hi

Why bother with moving data to other sheets.
Select the header row of your main sheet>Data>Filter>Autofilter
Use the dropdown on Client name>select BWC> and you will just have their
data visible.

If you do want to copy it to another sheet, just select those visible
rows>Copy>Select the relevant sheet>Paste
--
Regards
Roger Govier

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

__________ Information from ESET Smart Security, version of virus
signature database 4510 (20091015) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4510 (20091015) __________

The message was checked by ESET Smart Security.

http://www.eset.com