Copy part of a row from one worksheet to another worksheet based on a cell being updated.

[Kgreen214]

Hi,

I am trying to set this workbook up to create essentially an agenda of items to talk about.

As you can see by the below screenshot I have multiple tabs. Each color tab is different project. I need to copy a row (column A - Column J) from that tab and past in the next available row on the Summary Agenda tab when column I has been updated to via drop down to either Needs Update or Update. I then need the Summary Agenda tab to be sorted in order based on column A(i.e. A.1.1, A1.8, A.2.3, etc.)

 

[Kgreen214]

Hi Vcoolio,

Unfortunately I got the attached error when I made those updates. (AutoFilter method of Range class failed). Not sure what I'm doing wrong here

Hi Vcoolio,

Neverminded I figured it out. Thanks for your help!

 

[vcoolio]

Hello Karl,

Good to know that you've sorted it out. I'm glad to have been able to help.

Cheerio,
vcoolio.