Can anyone pls translate my pseudo cod ein VBA ???

  • Thread starter deepika :excel help
  • Start date
D

deepika :excel help

'DISTRIBUTION OF ESTIMATE
'estimate is the diff between hours in cells 12 and 13 of sheet1 (name of
sheet1 is WAS)
estimate = Cells(j, 12).Value - Cells(j, 13).Value

' a= the given planned start date from WAS
a = Cells(j, 7).Value

'check which column between cols 6 to 10 in sheet2(named FTP) does this
date fall in and store it in a variable called' k' and start distribution
from that col. say Sheets("FTP").Cells(i,k) where k can start anywhere
between 6 and 10.
loop if estimate >9
asiign that column starting at k to 9 ., i.e.,
Sheets("FTP").Ccells(i,k).Value=9
estimate= estimate -9
goto loop
else
Sheets("FTP").Cells(i,k).Value = estimate

I have to incerement thsi distribution to rows "i'' in ftp SHEET
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help required in completing the code 0
CAN ANYBODY PLEASE HELP ME WITH THIS MACRO 11
PLEASE HELP 0
CORRECTION NEEDED IN MACRO 0
Input boxes 5
Copy if code 1
Copy code failing 2
Copy code that partly works 0

Top