Hello!)
I need a macro that would be able to enter 4 different values (20,30,40 and 50) one after another into a single controlling cell. Two sheets – A and B – are dependent on this controlling cell. Their output is recorded in the corresponding sheets (A Output and B Output). These sheets record a random number of rows on each iteration. Each time the controlling cell is changed the macro would collect the non zero rows from the output sheets and place them on the master aggregating “A+B” sheet – so that after 4 iterations there will be whole list of output records. Please take a look at the attached worksheet.
Any help is hugely, immensely appreciated!)
The link to the file:
http://rapidshare.com/files/258133677/MACRO.ZIP.html