autofilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using autofilter I retreive parameters(Speed) by/per certain Last Name.
I want to add/copy new data (Time, for example, as another column) to this
selection. Copy/Paste/Special/Values doesnt work- fills only one upper cell.
Please, help.
 
You pasted into a range that was filtered?

If yes, then data|filter|show all.

You'll see you pasted into cells that were hidden by the filter.

If you're putting the same value into each of the visible cell, you could put it
in one of the visible cells (paste into the formula bar) and drag down.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to use cells as a autofilter 0
MS Excel 2003 - Autofilter for protected cells 1
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied 3
Possible Autofilter Bug (2003 and 2007) 5
Autofilter 10
Copy Autofiltered rows to another workbook using macro 2
Copy/Paste in Autofilter 2
Macro_creating sheets from AutoFilter list 1

Back
Top