I am in the process of creating a MultiPage userform that has 4 pages:
Page 1 = Project Information
Page 2 = Daily Meter Readings
Page 3 = Job Mix Formula
Page 4 = Natural Gas Usage
I have created a command button in the main userform called "Submit". When I click the "Submit" command button, I want the data entered in Page 1 and Page 2 to be stored in the "Sheet1" worksheet, some of the data entered in Page 1 and Page 2 and all data in Page 3 to be stored in the "Sheet2" worksheet, and some of the data entered in Page 1 and Page 2 and all data entered in Page 4 to be stored in the "Sheet3" worksheet. Does anyone know the best way to do this and reference code I could try? Would it be easier to send all of the data to the same worksheet and extract the columns I need into other worksheets (a one step process would be more convenient)? I am fairly green when it comes to VBA programming. Any help would be greatly appreciated.
Page 1 = Project Information
Page 2 = Daily Meter Readings
Page 3 = Job Mix Formula
Page 4 = Natural Gas Usage
I have created a command button in the main userform called "Submit". When I click the "Submit" command button, I want the data entered in Page 1 and Page 2 to be stored in the "Sheet1" worksheet, some of the data entered in Page 1 and Page 2 and all data in Page 3 to be stored in the "Sheet2" worksheet, and some of the data entered in Page 1 and Page 2 and all data entered in Page 4 to be stored in the "Sheet3" worksheet. Does anyone know the best way to do this and reference code I could try? Would it be easier to send all of the data to the same worksheet and extract the columns I need into other worksheets (a one step process would be more convenient)? I am fairly green when it comes to VBA programming. Any help would be greatly appreciated.
