Enter data in a Workbook worksheet and Save it in a other Worksh

Closed
jlockem Posts 1 Registration date Thursday June 13, 2013 Status Member Last seen June 13, 2013 - Jun 13, 2013 at 05:59 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 13, 2013 at 11:03 AM
Hi,

I Created a excel file requisition and user input details requesting materials
I need to have this data go to a other sheet with two section
1.) is the M section for all the header information
2.) is the D section with all the data information
I would also like to let it generate next auto number on save data button
how can I do this
the header in formation is in cells C1,C2,C3,C4.C5,C6,D2,D4,G1,G2,G3,G4.G5
THE DATA IS IN THE RANGE FROM column b10 - h10 and the column end where ever the line of data ends,
the requisition number is in C1 this is the one that needs to be generated on save,This number is also done with a prefix of MR or expanded on the department it wil be dMR or CMR est..
the form is in sheet Requisition and the data is then to me saved in MRdata sheet

Regards
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 13, 2013 at 11:03 AM
Hi Jlockem,

I have a hard time trying to understand what you are trying to achieve.

Could you post your workbook (without personal info) to a filesharing site like:
www.speedyshare.com
ge.tt

Clearly show how it is now and how you would like it to be.

Best regards,
Trowa
0