Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Sum Of A Column Depending On Data In Another Cell


I want to add up items in column H, but only if Column J says "yes" in the same row.

I tried a few methods as I always try to do, but I came up short with this one.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Data Validation Depending On Column
Let's say I have data validation on column A, which only allows 2 values, "Number" and "Letter". Easy enough. If the value "Number" is selected in A1, when the user moves to B1, I want a validation list of 1,2 and 3, when they move to C1, I want a list of 4, 5 and 6 and when they move to D1, a list of 7, 8 and 9. However, if "Letter" is selected in A1, when the user moves to B1, I want a list of R, S and T, when they move to C1, U, V and W, and when they move to D1, a list of X, Y and Z. I tried using dependant validation, but can only get all three columns (B, C and D) to either be 1, 2 and 3, or R, S and T. The validation lists would be existing named ranges on a separate sheet.

View Replies!   View Related
Adding Data In Column A Depending On Data In B
Adding data in column A depending on data in B. I have following macro:

View Replies!   View Related
Pasting Entries Into Sheets Depending On Data On A Column
Let's say I've got nine entries of data. Column A is aligned like this:

One
One
One
Two
Two
Two
Three
Three
Three

What I would like to do is write a macro so that the three entries with "One" in Column A get cut and pasted into a newly-created sheet named "One." All of the Two's get cut and pasted into sheet "Two" and the same thing with the Three's.

View Replies!   View Related
Loop: Macro To Go Through The Table And Preform An Operation In The Corresponding Cell In Column B Depending On The Value In Cell A
I have 2 columns and 10 rows (A1:B10). In column A are certain text values. How do I write a macro to go through the table and preform an operation in the corresponding cell in column B depending on the value in cell A? for example, if A3 = "Complete", overwrite the formula in B3 with the value (paste value)?

View Replies!   View Related
Change Cell Depending On Column Header
I have a spreadsheet with names and start / finish dates columns down the left hand side then a row of week commencing dates along the top.

for each name row I would like to change teh fill colour of a cell to green to represent the week in which they started and to red for the week in which they finished. I therefore need to cross reference the start and finish dates for each name with the relevant week commencing dates at the top. Somehow! I presume there is some kind of vlookup type formula that I need to use in conditional formatting, but I am not sure what.

View Replies!   View Related
Column References: Get A Cell To Return A Value Depending On Whether Or Not A Cloumn Is Populated
get a cell to return a value depending on whether or not a cloumn is populated
for example. If i Have 3 columns EUR, GBP and CHF and there can (99% of the time) only be one entry in any of the 3 on any given row. How then can i get a 4th column to return the value EUR, GBP or CHF on the same row as an entry. I have a relatively complicate nested IF fromula but i think this is slowing down the worksheet as there are 500 or so rows containing it. Ive attached an example segment

View Replies!   View Related
Replace Cell Content- Depending On Other Cell Data
I have a file consisting of two columns, called, "bom ref" and "material"
I need to show the data as indicated in the file, headed required format required.

In effect where I have a 0, that is the material I need to show for every row with a bom ref. of 1,2 or 3, down as far as the next 0 but not including the 0, when I reach the next 0, the material is a new letter, and that letter needs to repeat down as far as the next 0, but not including the 0 and so on.

View Replies!   View Related
Sheet Population Depending On Cell Data
I currently written the following formula, but always have issues when adding additional depending on selection.

D8 is the selection ( Validation ) on PERF EXP FORM Tab, Once you enter the selection... you then go to the Accounts per hour Worksheet
=IF('Perf Exp Form'!$D$8="Test1 14-18 station",IF(('10220DBHE'!B9=A6),IF('10220DBHE'!C9 > 11000,11000,'10220DBHE'!C9),"N/A"),"N/A")

Perf Exp Form
Perf Exp Form *ABCDEFGHIJKLMNOPQ4 *1. GENERAL INFORMATION****************5Customer***Date / Name(s)*6ApplicationSheet Size1UP/2UPOrientationSOG/EOGFold TypeFold Plate# CH***78 1/2 x 142 UPPortraitSOGLetter/ZHeavy1***8Machine / model**Enduro 4-6 station9ConfigurationCHANNEL 1CHANNEL 2CHANNEL 310590-4720-4910 Dual DeckNONENONE11Date / Name(s)*** Excel tables to the web >> Excel Jeanie HTML 4 ......


View Replies!   View Related
Extract Data Depending On Cell Information
i have 20 different materials which have codes assigned to them

wh = white
ivory = ivory
db = duck egg blue

etc etc

when i create an order some of the codes will be called up
i want to be able to put them codes plus the description into the worksheet Ideally into the header. if not call a1


View Replies!   View Related
Show A Certain Cell Depending On Data From A Drop Down Menu.
I have created a color coded calendar on a spreadsheet for work that shows when a book will be published depending on when it comes into our warehouse, this is on sheet one.

I would like on sheet two to have some kind of filter or statement that would eliminate the need to look at the calendar, I.E. the user would just have to type in the date or select the date from a list and excel would show you what day the book would publish on using the data from sheet one.

I can imagine that this is hard to picture so i have attached the file as well.

View Replies!   View Related
Dynamic File Path Depending On Cell Data
I think this is possible but cant find anything on it ........

View Replies!   View Related
Formula For Showing Data Depending On Cell Entry
I need a formula that displays the word "Day" or "Days" depending on cell entry i know the formlula =IF((B12)>0,"Day","") to show the word day but i want it to show "day" if a 1 is entered or "days" if any number over 1 is entered.

View Replies!   View Related
Average Column Depending On Values In Another Column
I have tried a few other examples in previous threads that use COUNTIF and ISERROR but I just can't get it right.

Basically I want to average the cells in column J (J2:J6,J8:J12,J14:J18, etc).
My aim here is to determine the average value for each day (Averaging 0 values in this instance is OK).

Now, the date in column A (A2:A6,A8:A12,A14:A18, etc) sometimes returns a blank value, depending on the day of the week (see attached example). This is because, in the full version of the workbook, I have Column A date linked to a perpetual calendar and therefore the dates can change cells depending on the year.

For the Date Cells that return a blank value, I do not want the AVERAGE equation to include the 0 value on these days.

For an example I have attached a month of February where there are blank date cells at either end of the column.

View Replies!   View Related
Set Range Depending On Value In Column D
I have a list of data in colum A and I want to group them together.

In column D I number the group with the same number.

A1 = Tony D1 = 1
A2 = Tom D2 = 1
A3 = Bill D3 = 1

A4 = Helen D4 = 2
A5 = Marg D5 = 2
A6 = Kathy D6 = 2
A7 = Catherine D7 = 2

And so on..... The list up to 100 names

As you can see group 1 = 3 names, group 2 = 4 names, group 3 = 6 or maybe 7 and so on.

I'm trying to set ranges for them Eg:
set rng1 = A1:A3
set rng2 = A4:A7

but it not fixed to set ranges like that. It's variable and changes every week. Next week maybe rng1 = A1:A5, rng2 = A6:A9.

can I have the VB code to determine these variable ranges.

View Replies!   View Related
Tally Report Of X: Count On Column B (project $) Depending On The Criteria On Column A (project Description)
I need to write a couple of functions. Firstly I want to do a count on column B (project $) depending on the criteria on column A (project description). For example a total count of all values in col B if project description is "P" or "A". [I can do sumif functions but this is a countif and I cannot get this right].

View Replies!   View Related
Select Range Depending On A Column
If i have row 10-20 in column A filled, what vba code would i need to select a range in column C that selects rows 10-20

If that 10-20 rows in column A chnages to say 10-50 the vba code will select 10-50 in column C

View Replies!   View Related
Summe Column Depending Of Other Columns
I want to create a macro that make the somme of 2 other columns when the nummer of the first column ist double(more than one ) and put the somme in a new Rows. like this :

A B
23 5
23 12
23 2
45 4
45 1
46 3 in the news the resultat in the same columns it´s like this
A B
23 19
45 5
46 3


View Replies!   View Related
Add Or Subtract Depending On Text Value In Another Column
I have a workbook to record the attendance of students. Sheet attendance9 for September's attendance. Enter 1 for present, 0 for absent, L for late, E for early leave and blank cell for no schoolday. Sheet "remark9" is used to record detail of attendance for September. In sheet "attendance9", I want to display in cell AT2 the number of times a student absent for 7 or 14 consecutive days. How to count from E2:AH2?

View Replies!   View Related
How To Sort A Column Depending On Number Of Letters
i want to sort a column in such a way that it starts with those cells having the highest number of letter. For example:

before:

AA
AAA
A
AAAAAA
AAAA
AAAAAAAAAAA

I want it to look like:

AAAAAAAAAAA
AAAAAA
AAAA
AAA
AA
A

Ofcourse the real list doesnt contain only "A"s. It contains of words and sentences.

How can i sort columns A as mentioned? The order of column A with other columns should not be destroyed be the sorting process.

View Replies!   View Related
Conditional Formatting: Format 3 Columns Depending On Certain Value From Another Column
I want to format 3 columns in excel depending on certain value from another column.
By example: I have the columns A B C completed with some text. On the column D it will be the numbers 0 or 1. If the number is 0 the background color from A,B,C columns shall be Green, if the number is 1 the color shall be red.

I have tried in conditional formatting with the formula =$D$1=0 but the color of the columns are changing only depending on the value from cell D1. I don't know what is the correct formula. For column A1 I want to check the value from D1, A2 - D2, A3 - D3,...,An - Dn.

View Replies!   View Related
Copy Rows To Other Sheets Depending On Values In Column
I’ve done a search of the forum for a macro and found some post that seems to be about what I want to do, but unfortunately my minimal vb experience prevents me from adapting them to my requirements.

I‘ve got a workbook with three sheets; say Sheet A, Sheet B and Sheet C. I want the info in Sheet C copied to either Sheet A or B depending on the info in cells in Column A of Sheet C.

Sheet C contains customer info, there are about 9 column headings and up to 30 000 rows (Individual customers).

The cells in Column A will contain a number between 0 - 23. What I want the macro to do is, if a cell in Column A contains any of these numbers, 0, 1, 2, 6,7,8,9,10,17,19,20,21,22,23, I want that whole row copied to Sheet A and if it contains 3,4,5,11,12,13,14,15,16,18, I want it copied to Sheet B. The cells will only contain one number, never a combination.

View Replies!   View Related
Calculate 10% Or 20% On Investment Form Depending On Interest Rate In Column
The way I have this sheet setup is to calculate a 20% fee off the interest earned column "D". Say you earned 6.5% on a beginning balance so the interest earned is in col "D". This works fine for a 20% fee but I need the fee to calculate a 10% fee if the interest in column "C" hit 4% or below and it also needs to be able to calculate a 20% fee if the interested earned is above 4%.

View Replies!   View Related
Sum Data Depending On A Date
I have a workbook full of a bunch of sheets with the same formatting. Each sheet has data for a 2 week period.

I am making a “master” type sheet and I’m hoping to be able to pull some data from each sheet.

On each sheet:
Row 1 has dates starting on E1 and ending on AF1 (several blank/combined columns)
Row 22 has the data I want to pull, and it is one column to the right of the date. So, F22 corresponds with E1…

Ex.
One sheet looks like this:
E1 = 8/24/09
AF1 = 9/6/09

I got single amounts to work by using:

=IF((MONTH(E1)=8),F22," ")

However, I’m hoping to find a formula that would look at the entire two week period and sum the row 22 amounts for each day that falls within a certain month.

I tried:
=IF((MONTH(E1:AG1)=8),F22:AG22," ")

Which comes back false since not all days in the two week period fall within August (8).

Does anyone have any ideas for a formula that would be easily changeable, and that would pull & sum row 22 data for each row 1 date that falls within a certain month?

View Replies!   View Related
Extracting Certain Data Depending On Criteria
Have a perfect working spreadsheet, but now need to extract certain bits of data depending on one criteria.

Each row contains data in different columns.

What i need to do is depending on the criteria of a cell (i.e. whether its Y or N) i would like to extract certain cells onto another worksheet all within the smae work book

i.e for example
If i have columns A,B,C,D,E and F and then x amount of rows (as these can change as data is entered) if a Y is entered in F then it extracts the data out of columns A, C and D

View Replies!   View Related
Moving Data Depending On Input
I new for a forum I have a small problem I just stock and can´t see what to do. So i need to move data from 4 columns B,C,D,E to F,G,H,I depending on input in column J, like if in J2 i enter letted M (or any from column A) i need to move data from B12,C13,D13,E13 to F2,G2,H2,I2 and so on. I dont have experiens in programming in exel or using formulas.

View Replies!   View Related
Calculating Several Data Depending On Date
I have a truck log. Every time some comes in to take a truck they must log the truck out with the millage. After a week, I am supposed to find out how many miles my trucks ran for that week.
What would be the code to....

In K column, calculate the milage that is in row F; which is A3 - A2 and so on down. But it would have to skip a line every time the truck number changes (in column C) it would skip that line. It would go until a blank cell.

Does anyone have any ideas how to do that?

View Replies!   View Related
Find Data Depending On Two Criteria
I Have want two find the dates and the data of these dates
depending on the two criteria i have

note"the two criteria would be left(b3,4) and right (b3,4)

ex
in f3"date" i want to find the dates correspond with these two criteria
and then find the data of these dates in G3 Depending on the two criteria too.

Sheet1

ABCDEFG2DateData
Criteria1Criteria2DateResult31/1/2008M111 GG1G M113
M191M1131/2/2008M191 G1GG M11341/2/2008M191 G1GG M113

1/5/2008M191 G78GG M11351/2/2008M111 GG1G M113

1/8/2008M191 G1G9G9 M11361/3/2008M141 GG5G M113

71/4/2008M118 GG6G M113

81/5/2008M191 G78GG M113

91/5/2008M141 GG5G M113

101/6/2008M111 GG2G M113

View Replies!   View Related
Formula To Change Cell Colour :: Shade A Cell Depending On Condition
Is it possible to use a formula to shade a cell dependent on a condition? I have tried an if formula (see below) but it is incorrect. =if('November 2006 SVOC'!B6>'March 2006 SVOC'!C6,'November 2006 SVOC'!B6 [red],if('November 2006 SVOC'!B6<'March 2006 SVOC'!C6,'November 2006 SVOC'!B6 [blue],))

View Replies!   View Related
Data Validations - Multipale Lists Depending On Each Other
I have search the site for a possible solution for my problem. And that is: how to create multiple lists using validation – depending on each other.

The scenario is. I have a data sheet that contains a list of alien plant species. The species have different methods of treatments (some do have the same). Each treatment might have one or more herbicide products that can be used and with each herbicide a certain application mixture.
I have used validation to create the pick list of the plants, the next pick list should be the treatment for the selected plant species and the 3rd list the product and then last list the mixture.
All of these lists should only list the information that is relevant to the selected plant specie, in the first list.


View Replies!   View Related
Copy Data From One Sheet To Another Depending On Date.
"Sheet1" of Book1.xls contains the daily efforts of each members in the team. The detail changes automatically everyday like:

Date Name Task1 Task2 Total
1/1/08 Mark Design-2 Analysis-2 4
1/1/08 James Design-3 Analysis-2 5
1/1/08 Paul Implement-4 4

On the very next day the details will be automatically changed as:

Date Name Task1 Task2 Total
1/2/08 Mark Design-2 Analysis-4 6
1/2/08 James Design-3 Analysis-2 5
1/2/08 Paul Analysis--8 8

i.e. "Sheet1" will contain only the details of current date.
I have managed to do it in "Sheet1"...

Here I need to add all the details automatically for each and every day in a separate worksheet ("Sheet2") from "Sheet1" of the same excel.

As soon as the date changed, then it will be reflected automatically in "Sheet2" in the next blank row for each member of the team...
The details of "Sheet2" will be:

Date Name Task1 Task2 Total
1/1/08 Mark Design-2 Analysis-2 4
1/1/08 James Design-3 Analysis-2 5
1/1/08 Paul Implement-4 4
1/2/08 Mark Design-2 Analysis-4 6
1/2/08 James Design-3 Analysis-2 5
1/2/08 Paul Analysis--8 8

View Replies!   View Related
Auto Hide A Row Depending On The Data In Two Cells
is there a way to auto hide a row depending on the data in two cells. Basically if two specific cells are empty or return a zero or specific number i want the row to auto hide.

View Replies!   View Related
Changing Cell Colours Depending On Cell Content
What I need to do is have a cell that will be say yellow until there is information put into this cell. The information could be in the format of text or numbers. The information would not always be the same so it would need to be yellow when there is no information in the cell and another colour or white when there is information in the cell.

View Replies!   View Related
Make A Cell A Color Depending On A Number In A Different Cell?
how to make a cell a color depending on a number in a different cell? Example...if A2 is 92.6 how would I make D2 blue? But if A2 were 91.9 how would I make D2 red?

View Replies!   View Related
Userform To Enter Data In Different Locations Depending On Selected Options
MONDAY
xxxxxxxxxxxxxTeam1 | Team2 | Team3 | Team4 etc.
Hours State1
-
Hours State2
-
Hours State3
-
etc.

TUESDAY
xxxxxxxxxxxxxTeam1 | Team2 | Team3 | Team4 etc.
Hours State1
-
Hours State2
-
Hours State3
-
etc.
WEDNESDAY
xxxxxxxxxxxxxTeam1 | Team2 | Team3 | Team4 etc.
Hours State1
-
Hours State2
-
Hours State3
-
etc.

Each team leader would then input hours in each state each day on their column. Make sense? Easy Peasy...

My question........... is it posible to have a userform where a TL would select their name (Column) and Day (Monday=Row 3, Tuesday=Row23 etc) from a dropdown and then input figures in txt boxes to submit them in the correct location?

View Replies!   View Related
Automatically Fill Data Depending On Choice From Drop-down Menu
I have three lists in the first sheet 'Food', 'Quantity', 'Points Value'
Each food (i.e. tuna, pasta, anchovies) has a quantity (i.e. 40g) and a points value (i.e. '50'). The first list ('Food') has been copied as a drop down list in the second sheet. When selecting a food, I would like the cells 'quantity' and 'points value' to pre-fill - taking the data from the first sheet.

i.e. if say Anchovies has the quantity value '30g' and Points Value '2' on the first sheet, then in the second sheet if anchovies was selected from the drop-down menu, these values would add themselves. how to do this? I have attached a sample file shwoing what I want to do.

View Replies!   View Related
Color After Depending On 1st Value In A Cell
I have another macro request.

I would like to ‘grey out’ a certain qty of cells depending on the 1st number in another cell. So 1st of all it would have to check in column B to see if there is any data and then check for the first number in that cell (there will be many numbers in the cells but we only need the 1st one (Ex.: B3 = “3 / 8 & 8”).

Then it should start counting from column D the found number of cells multiplied by 2.

Ex.: if Cell B3 contains “3 / 8 & 8” it will count 3 x 2 = 6 (3 cells x 2 = 6 cells)

Then, if after that count (now at I3), in the next cell over (J3) if the is data in the cell above (J2) then it should apply an Interior.ColorIndex of 15 for the next cells until there is no data in the cells above (if nothing after K2 the grey will be applied to cells J3 & K3 only).

View Replies!   View Related
Message Box Depending On Cell Value ...
I have a range C20:C38

In this range I have 15 codes that can be put in. If one of these codes is typed in incorrectly then a message box will appear stating "this code is incorrect please re-do"

can anyone help?

a few of the codes are
"S" "F" "O"

View Replies!   View Related
Cell That Changes Depending On Month
I'm trying to get the pink cell in THIS sheet to match up with the correct MONTH'S TOTAL in the pink highlighted column in THIS sheet. i couldnt figure out how to explain it any clearer.

View Replies!   View Related
Message Box Depending On Cell Value
What i want is for a message box to appear automatically when the workbook is opened ONLY if Cell C4 (which is merged to F4)...

If there is information in this box then do not run macro

in the message box I want a box you can type in that will enter that information into cell C4. I know I will have to us a user form but what is the code I need?

View Replies!   View Related
Row Color Depending On Cell Value
I was wondering if it is possible to fill a row with a color depending on the value of a certain cell. Say, if the value of cell N5 is 0 then row 5 turns red.

View Replies!   View Related
Check Cell & Act Depending On Value
Once again I strugle with how I write the title for my IF Function problem, but anyway.

This is my problem:
I have a spreadsheet to count times
column D and F is:
D Start
F Finish, on column G, I have "F-D"

I start in D2 and type the first time.
F2 = D3 and
G2 = F2-D2,

If I have nothing in D3 I got an error, and if I don't fill all sheet I also got an error. What I want is, in the end of the row I have a cell with the final time "D36" where "F35=D36" if I made only half a way lets say until "D19" then "F19" should be = to "D36" and not = to "D20", stopping like this the calculations, doesn't give me errors.

View Replies!   View Related
IF Statement (fill A Cell With Either 'YES' Or 'NO' Depending On The Value Of One Cell)
i'm trying to ask my spreadsheet to fill a cell with either 'YES' or 'NO' depending on the value of one cell. I've succeeded in getting it to enter 'YES' but can't figure out how to tell it to choose between the two options. This is the formula so far

=IF(L5>2,"YES")

View Replies!   View Related
Changing Range Of Sumproduct Function Depending On Length Of Data Series
I have a small problem using the ‘sumproduct function’ which I am using it to calculate the area under curves using the following equation (=SUMPRODUCT((B10:B109-B9:B108)*(D10:D109+D9:D108))*0.5). However I have hundreds of curves to calculate the area under and the length of the data series for each curve is different, I am currently changing the length of the data series by hand. I have attached an example worksheet of 2 sets of data (the formula I am using at the moment is highlighted in blue – row 203). Is there are function or formula that I can use inside this equation to change the range of the formula depending on the length of the data series?

View Replies!   View Related
Macro Disabled Depending On Cell Value
I was wondering if it is possible to prevent a macro from running depending on what value is in a specified cell.

I have a huge excel sheet and a commandbutton that runs a bunch of macros in order to generate a report.

I want to force the user to select a specific project before all the macros are run. Just making the report for a specific project only takes a few seconds but if no project is selected then it runs throught the whole database and it takes forever.

I have set up a cell that changes value depending on wether a project is selected or not. I have placed the cell in the -ForMacros- sheet. Now is it possible to write some code into the commandbutton that halts the report generation + displays a warning box telling the user to select a project first?

What values used to determine wether the macro runs or not doesnt matter to me. Whatever is easier for you

I have attached a sample workbook for you to work on.

View Replies!   View Related
Change Format Depending On Another Cell
I want to be able to do the following: I have data in column a and I want the text to change to strikethrough in, for instance, cell a1 when data is entered in b1.


View Replies!   View Related
Displaying A Particular Image Depending On The Value Of A Cell
I have 3 'speedometer' type images one for green, one for amber and one for red. I need to display ONE of these on a number of occasions depending on the value of a cell.

E.g.

If the value is 8.0 or above then I want to display the green one

If the value is 4.0 or above but below 8.0 I want to display the amber one

If the value is less than 4.0 I want to display the red one

View Replies!   View Related
Displaying Cell Depending On Date
My head hurts from working on this all day. I have a large spreadsheet and in the top left corner I need to show the percent of vehicles that are not working out of our whole pool. I have a function that detects the color of the cell (Red is broke) and counts the total of red cells and then divides it by the total giving the percent and it is in G118 for Jan 1/2007, H118 for Jan 2/2007 etc. I made a function that will count Julian days from Jan 1, so for today I get 114. I know I need to display G + 114 columns but have no idea how to get that column name from this and always display the current one in the corner.

View Replies!   View Related
Way To Name A Sheet Depending On The Content Of A Cell
on sheet1 cell a1 is there a way to make sheet1,s name appear as the contents of cell a1

View Replies!   View Related
'shift Cells Right' Depending On Value Of Cell
I need a macro that will "examine" the text of column B for every row checking to see if the text "Proper Text" is in the cell and if not, execute this code for that cell and then move on to perfrom the same until it finds an empty cell:

Selection.Insert Shift:=xlToRight
Range("B2085").Select
ActiveCell.FormulaR1C1 = "Click for detail image"
With ActiveCell.Characters(Start:=1, Length:=22).Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic

Note that "B2085" above is the cell number that the script stops on to execute this code.

View Replies!   View Related
Changes The Cell Color Depending On How Many Clicks
The code changes the cell color depending on how many clicks you give it.
The code it self works fantastic but the problem i have is if i manually unlock the sheet every time i click any where in sheet it locks it again.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo Error
Dim I As Integer, I1 As Integer, ws1 As Worksheet

Set ws1 = Worksheets("36hr Plan")
ws1.Unprotect "muppeticity"

I1 = 40
For I = 5 To 25 Step 5
For I1 = 22 To 204 Step 13
Offset1 = 0
If Not Intersect(Target, ws1.Cells(I1, I)) Is Nothing _
Or Not Intersect(Target, ws1.Cells(I1 + 1, 5)) Is Nothing _
Or Not Intersect(Target, ws1.Cells(I1 + 2, 5)) Is Nothing Then.............

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved