i want a create a conditional macro.

January 24, 2012 at 23:06:12
Specs: Windows XP
everyday we will get a transaction to process. As per that we have to allocate the total no. of invoice divided by no. of persons availability. Here only i was facing some problem to run the macro.Because everday i cant get the same data (total no. of invoice) and the no. of persons availability. It varies everyday as well as no. of persons also.
e.g. Today i'l get total no. of invoice 383 and no. of person 7 i'll allocate equally as everyone get 54 (383/7)to process. but tomorrow ill get total invoice like 450 and no. of person 5 or 4.. in this case how do i run the macro.

Please helpe me out to resolve this problem

See More: i want a create a conditional macro.

Report •

January 25, 2012 at 03:45:05
Total number of invoices should be a variable, getting its value from each days total (let's say variable A = total number of invoices)

Total number of persons available should be also a variable. (variable B = total number persons)

The macro should run the math as A/B.

Not knowing exactly what you are doing (is this macro being used in an access database?) I can only give very basic advice. Post back with greater details of what you need.

Please let us know if you found someone's advice to be helpful.

Report •

January 26, 2012 at 03:34:45
Thanks, but i didnt get clear idea from the last updated from yours.
first of all I'm beginner to the Macro. Everyday we'll get a volume to process the invoices and we'll allocate the total volume as per the person availability. So each day i'll count the total no.of invoices divided by no. of persons availabilty because we'll allocate to everyone as equally. in this case if i run the macro i cant get proper result. everyday i cant get same volume, one day i'll get 350 next day 200, another day 400 or 500 like it will come and no. of presence also. one of my friend suggested me that we have apply conditional formula in macro, then it will allocate as per that condition which we are given. But i dont that option how to get and follow thats y i need help to come out from this problem. we are i doing mannual allocate to everday which it takes nearly 40 to 50 min. If'll run the Macro I'll save time nearly 30 mins. So im thinking to go for Macro

I already given a example how it was. So once again i'll explain.
e.g. Today we will get a 400 invoices to process and no. of person is 5. Then i'll divided by total inovoices by no.of presence.then all 5 members will get 80 each(400/80). but tomrrow i'll get 250 invoices and 7 members then everyone will get 35 invoices to process.and next day i'll get 360 and 6 members then everyone will get 60 each.. like it'll fluctuate everday... In this case to avoid the time rather than going and allocate mannually to everyone i'll run the macro and save the time right?

If anyone is suggest it is very useful to me.

Report •

January 26, 2012 at 03:36:07
Can anyone explain how to audit CMD(customer master data) and What is T code for it?

Report •

Related Solutions

January 26, 2012 at 07:08:03
Usually invoices are dealt with by use of some business/accounting software. Despite the amount of text about your problems and handling procedures you haven't mentioned any software. What do you use in Win XP for this administration? Calculator and Notepad?


Wind slow

Report •

January 27, 2012 at 01:16:17
ramesh12, Sci-guy told you how. Guess you simply didn't understand. I'll have a go at clarifying. You are correct in your assumption that a macro to do the grunt math for you will speed things along, but you need to have it do the math on VARIABLES, not absolutes. Each day input values for the variables (A=x, B=y, etc.), THEN run the macro using those values and your result will be correct.
Ed in Texas

Report •

January 29, 2012 at 19:34:52
We will take dump from SAP tot Excel. then i'll use calculator to allocate...

Report •

January 31, 2012 at 22:55:46
Hi ED in Texas,

Cany please tell me that how to run the macro.. Please explain with an example then it would be help me...

Report •

Ask Question