Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I PLEASE NEED URGENT HELP WITH A FORMULA!!!
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I PLEASE NEED URGENT HELP WITH A FORMULA!!!
Hi
Why bother with moving data to other sheets. Select the header row of your main sheetDataFilterAutofilter Use the dropdown on Client nameselect BWC and you will just have their data visible. If you do want to copy it to another sheet, just select those visible rowsCopySelect the relevant sheetPaste -- Regards Roger Govier "Sarcalogus" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
Need Help with Formula-urgent | Excel Worksheet Functions | |||
If formula - URGENT | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Urgent Formula! | Excel Discussion (Misc queries) |