Ggtcf

Were any external disk drives stacked vertically?

What killed these X2 caps?

Is it possible to create light that imparts a greater proportion of its energy as momentum rather than heat?

Can I ask the recruiters in my resume to put the reason why I am rejected?

Forgetting the musical notes while performing in concert

How to show the equivalence between the regularized regression and their constraint formulas using KKT

Combinations of multiple lists

In a Spin are Both Wings Stalled?

Why can't we play rap on piano?

Etiquette around loan refinance - decision is going to cost first broker a lot of money

Do I have a twin with permutated remainders?

In Romance of the Three Kingdoms why do people still use bamboo sticks when papers are already invented?

What is the intuition behind short exact sequences of groups; in particular, what is the intuition behind group extensions?

How to take photos in burst mode, without vibration?

What is the word for reserving something for yourself before others do?

Could gravitational lensing be used to protect a spaceship from a laser?

Took a trip to a parallel universe, need help deciphering

UK: Is there precedent for the governments e-petition site changing the direction of a government decision?

Why is the 'in' operator throwing an error with a string literal instead of logging false?

Anagram holiday

Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?

Infinite Abelian subgroup of infinite non Abelian group example

Western buddy movie with a supernatural twist where a woman turns into an eagle at the end

Why is consensus so controversial in Britain?

Looping IF statement in VBA until value exceeded

Copy and paste cell value into until new cell value then repeat the processLoop through excel-spreadsheet-rows until empty using VBA-macro in powerpoint. For each row read values and write to 2-dim-array. No .selectStop loop VBA (Application.InputBox)Comparing cells in a loop with VBA'If … Then' statement with loopLooping a macro that changes date format in column A to column C then continue until it's reached the last used cell in column ARepeating a Macro in Excel untill it reaches a blank cellVBA to copy information down but on a loopSimple Do Until Loop in VBAHow can I write a continuous if statement that fires until a blank cell is reached?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I am trying to write an IF statement which will move down the cells in column E and change the value from 0 to 1.

I have the spreadsheet setup so when changing the 0 to a 1 it copies a value in that row from column C to Column F and I have a SUM totally Column F at the bottom.

I want the macro to move down and change 0 to a 1 while checking if the SUM at the bottom of Column F exceeds the number 50.

If it exceeds this I want it to change the value back to a zero and move to the next cell and repeat until it reaches a blank cell.

I'm a beginner to this trying to improve but this so far is beyond me.

excel vba

share|improve this question

asked Mar 8 at 23:27

Arch8491Arch8491

1

• 
  
  
  

  
  6
  

  
  
  
  
  
  

  
  
  Sounds fairly simple, this is a good beginners exercise. I recommend you read a little on "Do while loop", and/or "For loop". No more than a day's worth of reading to be able to do this by yourself. If you have code that it's not working, edit your post with it and we can try to help. Coding the whole thing for you, this is not what this site is for.
  
  – Ricardo A
  Mar 8 at 23:43
  

  
  
  
  

add a comment | 

0

I am trying to write an IF statement which will move down the cells in column E and change the value from 0 to 1.

I have the spreadsheet setup so when changing the 0 to a 1 it copies a value in that row from column C to Column F and I have a SUM totally Column F at the bottom.

I want the macro to move down and change 0 to a 1 while checking if the SUM at the bottom of Column F exceeds the number 50.

If it exceeds this I want it to change the value back to a zero and move to the next cell and repeat until it reaches a blank cell.

I'm a beginner to this trying to improve but this so far is beyond me.

excel vba

share|improve this question

asked Mar 8 at 23:27

Arch8491Arch8491

1

• 
  
  
  

  
  6
  

  
  
  
  
  
  

  
  
  Sounds fairly simple, this is a good beginners exercise. I recommend you read a little on "Do while loop", and/or "For loop". No more than a day's worth of reading to be able to do this by yourself. If you have code that it's not working, edit your post with it and we can try to help. Coding the whole thing for you, this is not what this site is for.
  
  – Ricardo A
  Mar 8 at 23:43
  

  
  
  
  

add a comment | 

I am trying to write an IF statement which will move down the cells in column E and change the value from 0 to 1.

I have the spreadsheet setup so when changing the 0 to a 1 it copies a value in that row from column C to Column F and I have a SUM totally Column F at the bottom.

I want the macro to move down and change 0 to a 1 while checking if the SUM at the bottom of Column F exceeds the number 50.

If it exceeds this I want it to change the value back to a zero and move to the next cell and repeat until it reaches a blank cell.

I'm a beginner to this trying to improve but this so far is beyond me.

excel vba

share|improve this question

asked Mar 8 at 23:27

Arch8491Arch8491

1

share|improve this question

asked Mar 8 at 23:27

Arch8491Arch8491

1

share|improve this question

asked Mar 8 at 23:27

Arch8491Arch8491

1

asked Mar 8 at 23:27

Arch8491Arch8491

1

asked Mar 8 at 23:27

Arch8491Arch8491

1