Is there a shorter/quicker way to do this?

S

SouthAfricanStan

I import daily a large database into Excel.. The data is contained in 20
columns and it is required that I sort in date and time order
I have "Deadline:20:40 26/6 Overdue" in A1
MID(A1,16,5) brings "26/6" in B1
MID(A1,10,5) brings "20:40" in C1
B1&C1 brings "26/6 20:40" in D1
Copy and Special Paste (Values) from D1 brings "26/6 20:40" in E1
I can them delete cols A to D (I need the space) and sort on col A, which
was previously col E
This is very time consuming - ia there any way I can do this in fewer
"steps"?
Thanks in advance.
 
G

Guest

Try Recording a Macro while doing the process one more time.......then just
run the macro in the future to do it all for you automatically.......

hth
Vaya con Dios,
Chuck, CABGx3
 

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

Averaging values from a list, based on user input 3
Need to work out a timesheet with times going into next day (>24 h 5
how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row 4
Syntax for using variables in a cell formula to reference paths/fi 4
change operating cells dynamically according to the value of a fixed cell 2
How to copy the function SUM but offseted in 7 columns 2
code snippet below. Is there a shorter way to do this type of thin 6
Simple subtraction formula returning strange results = Excel glitc 13

Top