Search:

Type: Posts; User: pr3ach3r; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Loop through spreadsheet and replace static subtotals with formula

    I think I figured it out with one exception:

    The last row of subtotals it does not do that row.



    Sub CleanupMasReport()

    countblank 'Function to get lastrow
    Dim x As Integer
  2. Loop through spreadsheet and replace static subtotals with formula

    https://imgur.com/YC0m2LPHopefully this make sense.

    I have this table I would like to loop through and change the subtotals to actual formulas.

    https://imgur.com/YC0m2LP

    My Thought was to...
  3. Replies
    6
    Views
    281

    Re: Help For Loop Problem

    Maybe I am still complicating my thought too much.

    Basic:


    If I put an x in column Q anywhere between row 3 and 46, and a number in any column between F and L in the same row. I want to sum...
  4. Replies
    6
    Views
    281

    Re: Help For Loop Problem

    http://i955.photobucket.com/albums/ae33/kmgoddard/excel.jpg


    You will note a 1 in column J8 and and X in Q8 but it is possible that there could be time placed in another column and time frame...
  5. Replies
    6
    Views
    281

    Re: Help For Loop Problem

    Maybe this explains it better:

    I have a timesheet with lets say:

    TIME ENG TIME ADMIN TIME RESEARCH TIME MUT
    8:00 AM 1 ...
  6. Replies
    6
    Views
    281

    Re: Help For Loop Problem

    They could place the x or the number it depends on the thought of the user. More than likey because its a timesheet and the it is dressed of course left to right they would probably put the number...
  7. Replies
    6
    Views
    281

    Help For Loop Problem

    Hopefully I can explain this well. What I am trying to do is if they put an x in column Q between rows 3 and 46 and a number in any column between f and l on the same row place that value as a...
Results 1 to 7 of 7