Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I Need An Argument
I'm trying to get information from the same colums located on multiple
(40)worksheets. I've adjusted the below formula many times using the =if, and & or but I'm getting "value", "non bowler", or it's skipping some of cell contents(see below): =IF(Sheet1!C7="non bowler",'Sheet1 (2)'!C7,Sheet1!C7) I'm stuck! Can anyone help me out with this one? -- Regards, **newdeas**<< |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I Need An Argument
I forgot to mention the colum range is c7:c46
-- Regards, **newdeas**<< "newdeas" wrote: I'm trying to get information from the same colums located on multiple (40)worksheets. I've adjusted the below formula many times using the =if, and & or but I'm getting "value", "non bowler", or it's skipping some of cell contents(see below): =IF(Sheet1!C7="non bowler",'Sheet1 (2)'!C7,Sheet1!C7) I'm stuck! Can anyone help me out with this one? -- Regards, **newdeas**<< |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I Need An Argument
This is pretty incomprehensible, but if I can guess: try the INDIRECT function.
-- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "newdeas" wrote: I forgot to mention the colum range is c7:c46 -- Regards, **newdeas**<< "newdeas" wrote: I'm trying to get information from the same colums located on multiple (40)worksheets. I've adjusted the below formula many times using the =if, and & or but I'm getting "value", "non bowler", or it's skipping some of cell contents(see below): =IF(Sheet1!C7="non bowler",'Sheet1 (2)'!C7,Sheet1!C7) I'm stuck! Can anyone help me out with this one? -- Regards, **newdeas**<< |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I Need An Argument
I'll try it again;
I have forty worksheets where I'm putting the names of different bowlers (location of bowlers are in c7:c46 on each sheet). If a bowler is absent I use "non bowler". I'm trying to find a formula that will look at all forty sheets and report back the active bowlers by not including the "non bowlers" found on most of the sheets. -- Regards, **newdeas**<< "newdeas" wrote: I'm trying to get information from the same colums located on multiple (40)worksheets. I've adjusted the below formula many times using the =if, and & or but I'm getting "value", "non bowler", or it's skipping some of cell contents(see below): =IF(Sheet1!C7="non bowler",'Sheet1 (2)'!C7,Sheet1!C7) I'm stuck! Can anyone help me out with this one? -- Regards, **newdeas**<< |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I Need An Argument
I don't know what you mean by "report back". I'll just assume you want all
the active bowlers listed in Column A of a sheet named "Active Bowlers". With 40 sheets and 39 names in each, your best bet is to go with VBA programming. This little macro will do what you want. Note that your file must have a sheet named "Active Bowlers" or change that name in the code to match what you have. HTH Otto Sub ListBowlers() Dim ws As Worksheet Dim c As Long Dim rColA As Range Sheets("Active Bowlers").Select Application.ScreenUpdating = False For Each ws In ActiveWorkbook.Worksheets If ws.Name < "Active Bowlers" Then With ws .Range("C7:C46").Copy Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues End With End If Next ws Set rColA = Range("A2", Range("A" & Rows.Count).End(xlUp)) For c = rColA.Count To 1 Step -1 If rColA(c).Value = "non bowlers" Or _ IsEmpty(rColA(c).Value) Then _ rColA(c).EntireRow.Delete Next c Application.ScreenUpdating = True End Sub "newdeas" wrote in message ... I'll try it again; I have forty worksheets where I'm putting the names of different bowlers (location of bowlers are in c7:c46 on each sheet). If a bowler is absent I use "non bowler". I'm trying to find a formula that will look at all forty sheets and report back the active bowlers by not including the "non bowlers" found on most of the sheets. -- Regards, **newdeas**<< "newdeas" wrote: I'm trying to get information from the same colums located on multiple (40)worksheets. I've adjusted the below formula many times using the =if, and & or but I'm getting "value", "non bowler", or it's skipping some of cell contents(see below): =IF(Sheet1!C7="non bowler",'Sheet1 (2)'!C7,Sheet1!C7) I'm stuck! Can anyone help me out with this one? -- Regards, **newdeas**<< |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use the argument: - IF, AND, THEN, ElSE | New Users to Excel | |||
what is an argument? | Excel Discussion (Misc queries) | |||
if argument? | Excel Discussion (Misc queries) | |||
One more Argument. | Excel Worksheet Functions | |||
IF THEN argument | Excel Discussion (Misc queries) |