How can I complete a spreadsheet using macros?

How can I complete a spreadsheet using macros?



The following is the scenario and request.



1.. Sheet 1 has been arranged to look like a form to enter data. A macro
clears all cells before entering new data.
2.. Sheet 2 obtains data from sheet by linking cells from sheet 1 & 2.
Some values are calculated in this sheet. Sheet 2 contains only one row of
data and it is cleared when cells on sheet 1 are cleared (link) for a new
entry.
3.. A macro to be run out from sheet 1 will go to sheet 2, copy the row,
go to sheet 3 and paste the data as values only.
I achieve the above sequence, but my problem is that when I enter new data
on sheet 1 that has to be coppied from sheet 2 into sheet 3 it replaces the
previous row on sheet 3. How can we get that the new data from sheet 2 be
pasted on sheet 3 below the previous record?



Hope somebody could provide me with a workable solurion.



Thanks in advance for you input.



Kind regards



Walter Heijboer

You have a reply at one of your other posts.

Walter Heijboer wrote:
>
> How can I complete a spreadsheet using macros?
>
> The following is the scenario and request.
>
> 1.. Sheet 1 has been arranged to look like a form to enter data. A macro
> clears all cells before entering new data.
> 2.. Sheet 2 obtains data from sheet by linking cells from sheet 1 & 2.
> Some values are calculated in this sheet. Sheet 2 contains only one row of
> data and it is cleared when cells on sheet 1 are cleared (link) for a new
> entry.
> 3.. A macro to be run out from sheet 1 will go to sheet 2, copy the row,
> go to sheet 3 and paste the data as values only.
> I achieve the above sequence, but my problem is that when I enter new data
> on sheet 1 that has to be coppied from sheet 2 into sheet 3 it replaces the
> previous row on sheet 3. How can we get that the new data from sheet 2 be
> pasted on sheet 3 below the previous record?
>
> Hope somebody could provide me with a workable solurion.
>
> Thanks in advance for you input.
>
> Kind regards
>
> Walter Heijboer

--

Dave Peterson