D
dgg160
HI,
I AM WORKING IN EXCEL 2003. I HAVE A SHEET THAT HAS 14 COLS. (A-N),
AND UNLIMITED ROWS (2-INFINITY). IN ROW 1 IS THE CALENDAR DATE. HOW
CAN I MAKE THIS SHEET AUTO SORT BY DATE AFTER THE 14 COLUMNS ARE
FILLED. (KEEPING THE SORT EXPANDED TO ALL 14 COLS).MOST OF THE COLUMNS
HAVE GENERAL TEXT OR GENERIC NUMBERS. ALL EXCEPT THE COLUMN "A". THIS
IS THE DATE COLUMN THAT I WANT TO SORT BY.
ANY HELP WOULD BE GREATLY APPRECIATED, EVERY MACRO I HAVE FOUND GIVES
ME "SYNTAX" ERRORS OR EXPECTED" " ERRORS.
I AM WORKING IN EXCEL 2003. I HAVE A SHEET THAT HAS 14 COLS. (A-N),
AND UNLIMITED ROWS (2-INFINITY). IN ROW 1 IS THE CALENDAR DATE. HOW
CAN I MAKE THIS SHEET AUTO SORT BY DATE AFTER THE 14 COLUMNS ARE
FILLED. (KEEPING THE SORT EXPANDED TO ALL 14 COLS).MOST OF THE COLUMNS
HAVE GENERAL TEXT OR GENERIC NUMBERS. ALL EXCEPT THE COLUMN "A". THIS
IS THE DATE COLUMN THAT I WANT TO SORT BY.
ANY HELP WOULD BE GREATLY APPRECIATED, EVERY MACRO I HAVE FOUND GIVES
ME "SYNTAX" ERRORS OR EXPECTED" " ERRORS.