I am having trouble figuring this out. I have multiple work sheets that I need to fill at the same time. I am using the "Form" command to enter data onto sheet 1 (which enters the info on the next open row). I want to enter this same info onto other sheets (of my choosing- possibly 2-3 out of 8) at the same time. populating to the next open row.
isthere a formula for this?