VBA to copy data from selected cells when one criterion is met

[lafleuk]

Hello-

I am new to the forum and to VBA, and have been searching to no avail for the correct code for my spreadsheet. I have data in a sheet called "Oversight Activities 2012-2013" with data validation. I will be inputting data into this sheet. When "A" is chosen in column A, I would like certain columns to populate under the appropriate headings in the sheet called "Reports" which contains only some of the same column headings and not in the same order.

I have attached the spreadsheet for your perusal. Can anyone assist please? I've zero experience with VBA. Thanks in advance

[jaslake]

Hi lafleuk

Place this code in the Sheet Module of "Oversight Activities 2012-2013". Right Click on the Tab ----> View Code. Paste this code in the Right Hand Panel. Let me know of issues.

Please Login or Register  to view this content.

[lafleuk]

Hi John,
Thanks so much for this, I cannot seem to get it to run though. It does not seem to be recognizing it as a macro...I have tried to run it from the VBA page and also tried using the macro-run command from the spreadsheet page, but the macros in this workbook window is blank. Any idea why?
Kara

[jaslake]

Hi lafleuk

Right Click on the Tab for "Oversight Activities 2012-2013" Click on tab.jpg

Select "View Code" and you'll see this screen VBA Screen.jpg

Paste the Code into this screen Paste Code.jpg

Fill in all the data for a line on "Oversight Activities 2012-2013" EXCEPT Column A. When all data is complete put an "A" in Column A. The Code will run as a result of Column A being an "A".

[lafleuk]

Yippeeee! Thanks so much for this John! I was puzzling over this one for a long while , am very grateful for your response and it works just as it should. Have a great day! Kara

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.