• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Can Excel Do This?

    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...
  2. S

    Carry balance with each new sheet created

    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 -...
  3. S

    Formula Help

    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...
  4. S

    Need Help With CF Rules [SOLVED]

    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...
Back
Top