Macro to save data to another worksheet.

[Guest]

Hello everyone,
Two complex (or simple, I don't really know) questions.
First part of the macro will look in cell B2 on worksheet "Design" and find
the number "1." It will then save data from several locations in the sheet to
one row (for example: 2) in specific columns on worksheet "Ships." Finally,
it will then return to cell B2 in "Design" and add "1" to the number, so it
will now read "2." The next time the macro is performed it will see the "2"
and save it on row 3 in the "Ships" sheet. Cell B2 may go up to 500.
I hope this is clear.
thanks,
Rob

 

[Rob Giordano \(Crash\)]

Sounds like an Excel question; this is a Frontpage newsgroup. Try:
microsoft.public.excel.misc


| Hello everyone,
| Two complex (or simple, I don't really know) questions.
| First part of the macro will look in cell B2 on worksheet "Design" and
find
| the number "1." It will then save data from several locations in the sheet
to
| one row (for example: 2) in specific columns on worksheet "Ships."
Finally,
| it will then return to cell B2 in "Design" and add "1" to the number, so
it
| will now read "2." The next time the macro is performed it will see the
"2"
| and save it on row 3 in the "Ships" sheet. Cell B2 may go up to 500.
| I hope this is clear.
| thanks,
| Rob