Drop Down List and Auto copy data based on date in cell to anoth

Question

Drop Down List and Auto copy data based on date in cell to anoth

[Closed]

Report

Nothing - Mar 8, 2016 at 02:17 PM
Blocked Profile - Mar 8, 2016 at 03:28 PM

Hello,

I need help fast. I'm not the resident expert my boss think I am apparently. Excel 2010. I imported info from a Word Perfect document which is almost useful. The dates copied one date less and other cells have to be entered manually but I can deal with that.

I need to 1) create a drop box. I've read every site I can find but its over my head how to do it. Just a simple drop down arrow by a cell that gives the person a few options, and they must choose one. I also need that drop down arrow box to be in every cell in that column, and I have many many columns that go to the right that this will be the case.

Also, in my worksheet two, I need to be able to have a date column that when a person enters a date in a row in that column, the information in that row automatically copies to a 3rd worksheet.

I am stumped and have very little time to complete this. Help?

Thanks-M

Drop Down List and Auto copy data based on date in cell to anoth
Excel data validation drop down list multiple columns - How-To - Excel
Highlight Cells Based on Drop Down List Selection ✓ - Forum - Excel
Change cell value based on drop down list excel ✓ - Forum - Excel
Drop down list excel français - How-To - Excel
Excel 2007 drop down list not working ✓ - Forum - Excel

1 reply

Ask a question

Blocked Profile · Answer 1 · 2016-03-08T15:28:17-0500

Answer 1 / 1

Blocked Profile
Mar 8, 2016 at 03:28 PM

Ok, you make the Drop down object and load a range into it.

You should be presented with this:

Have fun!

I have said it once, I will say it again. IT!

Drop Down List and Auto copy data based on date in cell to anoth

1 reply

Your reply

Subscribe To Our Newsletter!