Need help to selectively autopopulate secondary sheet from mastersheet

[RYANSCAT01]

I am new here and hoping for a solution or some guidance. I am reformulating a master tracking sheet for building projects. Many columns of data per entry project. out of all the rows(projects) there are a select few that are assigned a priority number 1-50 in one column. I would like to create a sheet that pulls certain columns of data from the rows on the mastersheet that are assigned a priority number.

[Mumps1]

It would be easier to help if you could possibly post a copy of your file with a detailed explanation of what you want to accomplish. Use an example and refer to specific cells, ranges and worksheets.

[RYANSCAT01]

test copy STAN PAC-2015 LOTS.xls


I need to create a sheet that pulls columns A-D,K, and N-AF of any row that has a numerical value in column A from the masterlist sheet. The amount of overall rows and the rows that have a numerical value in column A will constantly change.

[Mumps1]

Try:

Please Login or Register  to view this content.

The data will be copied to Sheet2.

[RYANSCAT01]

I have tried entering this into the sheet code and even tried adding as a macro on a button. I can not get it to do anything. Am I entering it incorrectly?

[Mumps1]

Try the attached file. The macro is in Module1. You can run it from there. Keep in mind that the macro also copies the formulas from the MasterList. If you don't want the formulas then the macro will have to be changed slightly. Please let me know.