Search:

Type: Posts; User: ROBJ

Search: Search took 0.01 seconds.

  1. Good Day, How can the INDIRECT formula be used...

    Good Day,

    How can the INDIRECT formula be used for the formula in cell C5 ( =SUM('JAN START:JAN END'!C5) ) to update automatically based on a drop down menu in cell A1 which allows to chose the...
  2. Thank you :) Sorry about that. Cheers ...

    Thank you :)

    Sorry about that.

    Cheers

    Rob
  3. Code to copy the active WS before a specific WS in the WB

    Hello there.
    I have the following VBA code. This one creates a new WS at the end of the WB. I need however to copy the current (active) sheet and be able to copy it before a specific sheet. What do...
  4. Hello :) Please see attached. I might have...

    Hello :)

    Please see attached. I might have answered my own question by adding a "helper" WS before the 1st & last week of the month for formulas to update. " =SUM('JAN START:JAN END'!C5) "
    Not...
  5. Hello :) I tried to upload the file but is...

    Hello :)

    I tried to upload the file but is larger than 102kb and it would not allow me.
    For an easy analogy, the WS containing the data that need to be summed in the monthly WS are the weeks of...
  6. Sum the same cell across multiple sheets - variable number of sheets

    Good Day,

    I have a typical set of month sheets (labelled: Jan Total... Feb Total... etc.) and a "YTD" sheet. All month sheets have identical layouts. The YTD sheet also has an identical layout.
    ...
Results 1 to 6 of 6