Possible to auto populate the data that i wanted from a main list to specific template

hi all,

Appreciate if u can help.

I have a excel spreadsheet (main list) which needed my staff to fill in. I also planning to insert another excel form on another sheet.

Lets say i have 10 rows in main list, but i only want certain rows to be inserted to another excel form for approval.

How can i make the automation for this?

How do you determine which rows should or should not be inserted to the other sheet? Post a sample workbook with any sensitive information removed, and preferably also with the desired results in another worksheet.

Originally Posted by millz

How do you determine which rows should or should not be inserted to the other sheet? Post a sample workbook with any sensitive information removed, and preferably also with the desired results in another worksheet.

excelforum.xlsxexcelforum.xlsx

Sorry if there is any confusion as its my first time posting here. Here is attached file.

I will only want rows with P entered in the first column to be populated into the form. Entry in "Sample Form" is what i expected.

Try this. Open workbook, enable macros, and click the button in the worksheet "Sample Form"

thank u very much! could you teach me how to create the button and the command also?

Welcome.

To create a button, you need to enable the Developer tab in the ribbon.
Click on Office menu, Excel options, under Popular, tick 'Show Developer tab in the Ribbon' checkbox. (May differ in Excel 2010, I am not sure)

Now on your menu you should see 'Developer', go there and click Insert -> choose Command button under ActiveX control.
With your mouse, just click and drag on the worksheet to create the button as you would do a Shape object. By default you should go into Design mode (indicated by depressed button in the Ribbon), then double click on the button you have just created, this should bring you to the VBA editor. You can code the commands from there.

As for teaching you on how to start programming VBA, I'll leave it to the online guides out there. You can also check here when time permits.