Search results

Look in a column and find a specified value, and then add the totals from a different column, across all sheets in the workbook. For example, let's say I have two columns on all my sheets in my workbook. In column A, I have serial numbers; in column B, I have dollar values. Can I tell excel to...

@ NARAYANK991 Yes, the macro in question is meant for the work in question. Not sure I understand your question: " What I mean is , will the sheet corresponding to the week number exist when the macro is run ? What should happen in such a case ?" But I'll try to answer it. The original macro...

Sorry I didn't check back sooner. I used to get email notifications when there were responses to my posts... Anyhow, in both suggestions, when I run the macro and name the week "1", H2 goes blank, as it should, and D2 will show $831,607.00 but any new sheet/week created after that generates...

I have this code used for my macro: Option Explicit Sub CreateNextWeek() Dim WeekNbr As Long WeekNbr = InputBox("Enter the week number.") Sheets("Template").Copy After:=Sheets(Sheets.Count) ActiveSheet.Name = "WE (" & WeekNbr & ")" Cells(2, "D").Formula = "='Week (" & WeekNbr -...

Thank you, Hui. Your suggestion works perfectly.

On the attached workbook, the 4th tab, I would like some help figuring out the following: 1. Columns T through W will return "1" or leave cell blank if conditions are met. -By the way, I have the condition formulas structured, albeit poorly. 2. Since the amount of rows of data will always...

Narayan , Thank you for your assistance. What you have provided me is precisely what I was looking for.

NARAYANK991, The dates for the actual outcome will all be in the future, but for purposes of testing the rule(s), I used a date that has passed. In other words, I wanted to know if I had the formula right, so if formula was right, blank cells would highlight red because the referrenced due...

SirJB7, Next to table 3 I put an example: Example of highlight if due date is X days away where "X" = date range of: 30+ 15 to 29 6 to 14 < 0 to 5 Under each column is a hypothetical date. So, given my goal, if due date is 7/30/13, it is 30+ days away, so I would like the blank...

All right... Here is the link to the sample worksheet. Sheet 1 shows the problems that I ran into. I have descriptions of the problems next to the charts. I believe your explanation above address this problem. Sheet 2 is the actual sample in which I would like to find a way to highlight blank...

Thank you again, SirJB7. Your explanation does indeed help. As you can tell, i'm but a novice at stuff. I'll submit a sample of what it is I'm working on in a few hours. I believe that my problem now is that rules I created conflict each other.

SirJB7, Thank you for your quick response. I've read through the green and I'm quite familiar with forum etiquette; I help people with PC problems on another forum. I've also tried finding a topic close to mine, but alas, nothing even close, well at least not in the first three pages. I can...

I have a spreadsheet that I'm working on. What I would like to do is have the cells in the range fill/highlight with a certain color, based on the current date and the date a training activity is due. For example, I have a chart of 17 employees with 10 training activities that i'd like to...