Hello,

I would like to ask for your help in creating a macro to run a batc
process, specifically doing the following:

1. Copy from Clients worksheet cell B2, then Paste Special (value)int
cell E12 of Forms worksheet.
2. Copy value from Clients worksheet cell C2, then Paste Specia
(value) into cell E14 of Forms worksheet.
3. Copy value from Clients worksheet cell D2, then Paste Specia
(value) into cell E17 of Forms worksheet.
4. Copy value from Clients worksheet cell E2, then Paste Specia
(value) into cell E19 of Forms worksheet.

(The spreadsheet will now be able to compute for the needed analysi
once all the four (4) entries above have been placed.)

5. Copy value from Computations worksheet cell CQ, then Paste Specia
(value) into cell F2 of Clients worksheet.
6. Copy value from Computations worksheet cell B6, then Paste Specia
(value) into cell G2 of Clients worksheet.

Now, the spreadsheet must be able to *save* the computed values paste
in both cells F2 and G2 of Clients worksheet for the first client, eve
if the requirement now is to *clear* its information from the Form
worksheet so that it can now compute for the second client doing th
same process (this time obtaining information from the 3rd row o
Clients worksheet). It will capture the results then perform simila
operation for n # of iterations until it finds the last client (as fo
my case, it'll be the 3,000th client).

Also will there be a problem to run this batch process as far a
accuracy of computations is concerned? For when I do this manually i
takes excel 97 about 10-15 seconds as it refreshes to calculate pe
client.

I currently have 3,000 clients that I need to plot using their require
computed values. How do I create this macro to run computations for al
these clients on a one-time-basis?

Really appreciate all the help you can give in resolving this.

Marij

--
Message posted from http://www.ExcelForum.com