how do I sort by picked-up date in Excel

  • Thread starter equipment repair
  • Start date
E

equipment repair

I am a novice working in Excel. I am trying to start a new sheet and
transferring information from the previous month. I only need the
information on the equipment that has not been picked-up without having to
redo a whole new document.
 
E

Eduardo

Hi,
I assume you have a column where you enter the date on what the item was
picked up, if that is correct, apply filter to that column and select the
blank cells, then highlight all the information you get, press CTRL + G,
special, visible cells only, press CTRL + C, go to the sheet where you want
to copy the information, press CTRL + V
 

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

Setting up a list where an item can only be picked once in Excel 2
how do i remove page breaks in excel? 1
Excel 2003 make 1 date cell automatically change another date cell 3
Sort Date Column 3
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Transfer info to new sheet by date 4
Date and Text in one formula 10
How do I sort by entry date? 4

Top