Create a list for specfied person from long list

Hi,

I'm looking for hep with macro's excel 07. I manage a number of build managers that need to provide actual and forecast date info into report which is then highlighted to show the cells that have been updated. Then Admin checks the report and uploads the amended date information to a database.

Just togive you an idea of my knowledge on Excel, I am not an excel guru but can write small formulas and do vlookups, so could do with some help on how to approach this.

The column which provides the persons info is 'F' this is located on Sheet 'ITB' I also have created a sheet called summary this is where im thinking of having a Macro which creates the relevant list for each person. but im also unsure if it would be easier to have a list per person which is populated from the main 'ITB' list.

Can i have your thoughts on this?

I have attached the spreadsheet for your info.Build Manager Instructions.xlsx

Thanks for reading

John

John,
The summary is blank, so we do not know what your lists look like. What is a list? What are trying to do?

Originally Posted by AB33

John,
The summary is blank, so we do not know what your lists look like. What is a list? What are trying to do?

Hi,

Thanks for your quick resonse. I'm trying to create lists for individual people (column F) (8 people in total) that will give all the rows that they are refernced against in ITB sheet.

Can this be done without applying filters etc, i want to click a name or pick it from a drop down to then show all the rows with their name listed in column F on ITB sheet.

The purpose of the report is for the persons to update with forecast and actual dates of milesones listed across the columns on the ITB sheet. Then an Administrator would use the dates to update a database with the info updated only.

Does this make sense?

Cheers,

Build Manager Instructions.xlsxHi,

I'm struggling to explain what i need here. please bare with me I will try again hopefully it will make sense this time.

I have to run a report from a large table of data, i want to display the data for each variable (persons name) into seperate sheets for each variable (persons name, column F) i.e. i want to display all rows of data relating to names in column F. I want the data to list under the relevant sheet which is named as per the persons name in column F.

Please see my report attached for your info.

Attachment 233835Hi,

I'm struggling to explain what i need here. please bare with me I will try again hopefully it will make sense this time.

I have to run a report from a large table of data, i want to display the data for each variable (persons name) into seperate sheets for each variable (persons name, column F) i.e. i want to display all rows of data relating to names in column F. I want the data to list under the relevant sheet which is named as per the persons name in column F.

Please see my report attached for your info.

Try the attached.

John,
The code clears all data in all sheets, except the master sheet and repopulate the tabs(sheets) with fresh data. In your case, the master sheet is ITB sheet. All you have to do is: Update the data in master sheet(TIB) and run the code. If you change the master sheet(TIB), you need to change two lines on the code, but I do not know your code skills. The other option would be copy all your new data in to sheet TIB, or delete the old TIB sheet and replace with a new sheet, but has to be the same name, TIB.

Will doze-off for now and will carry on tomorrow.

John,
If you are not familiar with running a code, I could attach a button on the master sheet and you then press it to run it when ever you want. The code should work with any amount of data, but it may slow down(Speed of execution) running it as you increase your data.
It is not hard to run it yourself. The code is stored in project window, under the name of a module. To access the module, press ALT+F11 will take you to the module. Once you are on the module, choose run from the menu or press F5 to run it.