Macro to save data to another worksheet.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top