Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Getting Values Based on Conditions
I have a spreadsheed that is pulling data from another worksheet, sorting it then using that data to fill in the cells on my report. 1. Column "a" is a project name and Column "b" of the is a start date. 2. Columns "c" through "ad" are weeks where Row 2 contains dates for the begining of each...- Randy1234
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Loop through rows completing tasks in each row conditionally
I need a little assistance with a code that I am writing for one of my worksheets. Here is what I am trying to do: 1. loop through each row 1-200 2. If the cell in column "Z" is > 0 then 3. Goalseek the cell in column "AS" of the same row to 0.25 by changing the cell in column "X" of the same...- Randy1234
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Setting Ranges to Format in VBA
Hi Everyone, I have a major issue that I hope can be solved since I have spent about three days trying to figure this one out. I have text in range1 ("A18:A300") but not in every cell. There are also numerical values in range2 ("G18:BB300") but not in every cell. As the values change in...- Randy1234
- Thread
- Replies: 11
- Forum: Microsoft: Office
