# Search:

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

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

by pr3ach3r
Replies
1
Views
72

### 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. ## Thread: Loop through spreadsheet and replace static subtotals with formula

by pr3ach3r
Replies
1
Views
72

### 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. ## Thread: Help For Loop Problem

by pr3ach3r
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. ## Thread: Help For Loop Problem

by pr3ach3r
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. ## Thread: Help For Loop Problem

by pr3ach3r
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. ## Thread: Help For Loop Problem

by pr3ach3r
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. ## Thread: Help For Loop Problem

by pr3ach3r
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