Auto-populating data into one spreadsheet from another table

[excelhelp112]

Hi,

I need help in auto-populating an Excel spreadsheet from another Excel table. What I want to do is to create a table with 4 drop down lists: project (colour-coded) - stakeholder - start date - end date - person responsible. I want the information presented in the table to auto-populate a separate spreadsheet. The spreadsheet needs to be ordered by stakeholder and date.

So, basically, the user will input the following information into the table using drop down lists:

'Social media plan - members - 04/01 - 06/01 - Amy'

And then in the spreadsheet the information will automatically go to the 4th of January in the row for 'members' and in the relevant cell it will have 'social media plan - Amy'

Is this possible? And if so, how would I go about doing it?

Thanks in advance for your help, I know this is a bit vague, but I am new to this programming side of Excel.

[vichopalacios]

hi @excelhelp112

project (colour-coded) - stakeholder - start date - end date - person responsible
'Social media plan - members - 04/01 - 06/01 - Amy'

you posted 5 columns and say 4 dropdowns
please clarify this.

Is this possible? And if so, how would I go about doing it?

Yes, it is possible to create a code to do this task...
which columns have the dropdowns?
how long are the list for your dropdowns?
where are the lists?