Quick and simple way to sort data (2000)

Topic

New Reply

Image reduced in size by HansV

I am trying to find the easiest and quickest way to do the following , as l have to do it on a regular basis.

1.sort the top spreadhsheet so that it only show the rows where Acnowkledged field is equal blank.

2. Show the relevant columns names. (see bottom spreadsheet example)

3 To insert the approproate name in the “Who Raised Lot” field . These names are from a word document.
I have to keep copying and pasting them , is there any way this information can be read automatically from a Word document as l have to keep copying and pasting it all the
time.

The current way l do this is to:

1. Use a filter

2. Remove unneeded columns.

3. Type in relevant names in “Who Raised Lot” field.

Reply | Quote

Replies

You’ll have to provide (much) more information – we don’t know how the names are stored in the Word document and how they can be related to the data in the spreadsheet.

Reply | Quote

see attachment for how names are stored in Word

Reply | Quote

And how can we determine which name belongs where in the spreadsheet? Remember, you wanted to automate this. Computers are stupid, so you’ll have to provide very clear, complete and unambiguous instructions.

Reply | Quote

It is quite difficult to determine this. The only way l can think of is that if you look at the document number then go to the bottom of the page of that document you can then find the approproiate name of the person at the bottom.

Reply | Quote

That is not enough to automate it.

Reply | Quote

It looks as though l will have to use the current method l am using

i.e use autofilter , remove relevant columns then add names.
Is there a way to automatically use autofilter and remove relavent columns, if not l will have to use the current method l am using.

Reply | Quote

Try recording a macro. You can assign the macro to a toolbar button and/or keyboard shortcut.

Reply | Quote

The problem with doing a macro is that when l run the macro l will need to make changes to the spreadsheet and l don’t want to make changes to the spreadsheet.
Is it therefore possible to make a copy of the spreadsheet and run this macro on a copied spreadsheet and then run the macro on the original spreadsheet by calling the one copied spreadsheet (if you see what l mean).

Reply | Quote

Yes, but make sure that you test the macro on a copy of the workbook too.

Reply | Quote