generate multiple rows with vba

kindly view the attachment and help in my project

regards

I think you need to do a whole lot more explaining before anyone can help you on this. Also, it's poor form to force someone to open a file to have any idea of what you're needing help with.

sir you are quite right but to elaborate it will be very long and in excel in sheet1 there is data and in sheet2 there is result

Plz see once ..it has been elaborated too easily

There are so many experts here who have always helped me-kindly assist

its a very small job for you -i know

changed the title for better understanding

Kindly assist if i should do somehing kindly tell me

sir

why i am not getting the reply cant understand ...kindly help

I would recommend you start a new thread. In your first post, fully describe the issue you're asking for help with (spend some time and effort getting this part right. if a reader doesn't understand what you want, he won't respond to your post in most cases). Second, post a workbook showing what you're wanting to go from and what you want it to look like after. If it's not obvious how to go from beginning to end (in other words, if there are rules regarding the arrangement of the data, or calculations needed) make sure you document this so the reader understands what's needed.

Again, to emphasize, IF you don't explain what you're wanting to do, most folks won't respond to your post.

Deleted; dupe post

ok sir i will start a new thread

there are so many experts and gurus on vba and other forums kindly help...

before a start a new one

Maybe:

Please Login or Register  to view this content.

thank you very much sir i will try and reply you soon...

thank God

you have responded sir,the code is working absolutely as i wanted. some facts i would like to share with you regarding this code

its giving value as 20*25

where as in those cell i needed the multiplied value i.e 500 and likewise in cells where values with "*" are coming i need multiplied valuee sir

second thing the code is also generating a row for corresponding zero value against codes like it is generating for code 19 in column g where as if against any code in any column zero is there our vba code should not generate row against such colum(purticular cell) for other cell it should generate.

the code is also generating an extra row for last code 19? which is not required

i have added to more columns for " eligibilty for Lunch" and eligibilty for Entertainment -kindly adjust the vba code to generate rows against them also

for output attaching the sample file again.

Thanking you in advance

Because of people like you this forum is Great!!!!

new sample with added two columns rest it is same as previous one

uploading a new sample with two new added columns rest it is same as previous one

regards

HTML Code: 

Kindly assisst for modification of code -new sample attached sir...

Let it generate rows for corresponding zero columns also kindly just modify the code as i have addedd two more columns and it is generating an extra last code kindly correct that also

Try:

Please Login or Register  to view this content.

This is fine but still it is giving value as 20*25 where as it should give multiplied value as a result in that cell that is 500 as a result

Modified:

Please Login or Register  to view this content.

sir this code is giving multiplied value of petrol for one code only

for every code i want the same result sir..

dont need * any where for petrol, i need the multiplied value for every code sir

and when i am increasing records by adding rows of new employee it is not generating result for subsequent rows

Yes your modified code is working fine now but it is not clearing old data in sheet2 before writting which is creating problem

somebody kindly assisst

Column d??

In which column the eligibility of petrol is there sir

if the eligibility is more than or equal to 100 then in result instead of multiplied value with petrol rate -only the eligibility of petrol should come as result

sir am i not clear -should i explain anythingels

sir

it is giving runtime error 5

invalid procedure call or argument

for
b(n, 3) = UCase$(Split(Mid$(a(2, ii), x), "(")(0) & " of " & myMonth)

sir now i was able to use this code but your code is giving me the result with multiplied values only where as the requirment is that if the petrol eligibilty is more than 100 then the result in sheet 2 should not be the multiplied value with rate of petrol it should be only eligility of petrol


rest formula should function the same

HTML Code: 

this code was working fine

only it was not clearing the old data in sheet2 before writting new one

and the above stated problem is there with this formula also

You should show us exact results that you want.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

ok uploding a sample soon

These lines clear the old data in Sheet2 before the other processes are run.

Please Login or Register  to view this content.

Sheet 1 is data sheet2 is result sir

John sir your code is doing everything except one thing that is if the value in column for eligibilty of petrol is more than 100 than in sheet 2 in result should be the only eliglibility not the multiplied valued

Can you confirm that what you have in your sample in Sheet2 is the results that you actually want?? It is confusing. You're saying that you want a multiplied value. Then your sheet2 should have that multiplied values as a result. Does this help?

Please Login or Register  to view this content.

yes sir sheet 2 is result

the code which you have pasted gives multiplied values for all the clomns value

were as the multiplied values are required only for column eligibility of petrol
rest of the values of other columns will go as it to sheet2 as a result-but if any value in column eligibility for petrol is more than 100 the it should go as it is in sheet2 as a result

for example if value in column eligibilty for petrol is 10 then the result in sheet2 in respective column will be 25*10 that is 250 finally as result but suppose if value in column eligibilty for petrol is 200 then in sheet2 result should not be 200*25 it should be only 200 that is what i wanted to say

HTML Code: 

this code was working fine

it was just not doing the above

fpr jindon sir

runtime error 13

type mismatch for b(n, 4) = a(i, ii) * IIf(a(i, ii) < 100, a(i, UBound(a, 2)), 1)

Did you try the code in Post 41?

Maybe like this ?

Please Login or Register  to view this content.

Kind regards
Leo

Originally Posted by ROHAN999

fpr jindon sir

runtime error 13

type mismatch for b(n, 4) = a(i, ii) * IIf(a(i, ii) < 100, a(i, UBound(a, 2)), 1)

Is something wrong with your Excel?

Yes sir i have tried post 41 ,its absolutely fine also taking care of >100 condition also

but there is only one problem with this code

it is giving multiplied valued for all columns like petrol, mobile , entertain etc etc..

Where as the multiplied values are only required for the eligilbility for petrol

just an FYI:

but to elaborate it will be very long

People generally won't bother giving their own free time to help if they see you aren't willing to give your time to explain. This is probably why you didn't get a response for so long.

Maybe that will help you in future.

leo your code is doing all but the narration are wrong - it should come like petrol for the month of sep 16....like wise

kindly see in sheet2 the narrations are changed than that of in sheet1 as when the eligibility is multiplied with value of petrol@ then the result value will not remain eleigibility

so in result sheet2 narration have been changed

in john sir code narrations are coming correct

leo-except narration issue your code is doing everything else

Originally Posted by ROHAN999

Yes sir i have tried post 41 ,its absolutely fine also taking care of >100 condition also

but there is only one problem with this code

it is giving multiplied valued for all columns like petrol, mobile , entertain etc etc..

Where as the multiplied values are only required for the eligilbility for petrol

OK Then:

Please Login or Register  to view this content.

Thank you sir

You're welcome. Glad to help out and thanks for the feedback and the reps.

Because the file in #1 contains 8 colums and later onother file with 10 columns

this one can handel both

Please Login or Register  to view this content.

Kind regards
Leo