E
edinclimb
I have filtered data in two columns which display a specific day of wee
and the corresponding date. i.e. the day is sunday. i want to only cop
the day and date from the filtered data and paste it in tw
corresponding columns. when i do this it pastes the whole value
(monday to sunday) and i only want to paste the sunday. so when i sho
all on the auto filter i have blank cells for the monday to th
saturday and only values in the sunday column. i have attched an imag
of what i am looking for - i dont want to have to copy and paste thi
individually for 3000 rows!!!!!!!:confused
+-------------------------------------------------------------------
|Filename: capture.jpg
|Download: http://www.excelforum.com/attachment.php?postid=4177
+-------------------------------------------------------------------
and the corresponding date. i.e. the day is sunday. i want to only cop
the day and date from the filtered data and paste it in tw
corresponding columns. when i do this it pastes the whole value
(monday to sunday) and i only want to paste the sunday. so when i sho
all on the auto filter i have blank cells for the monday to th
saturday and only values in the sunday column. i have attched an imag
of what i am looking for - i dont want to have to copy and paste thi
individually for 3000 rows!!!!!!!:confused
+-------------------------------------------------------------------
|Filename: capture.jpg
|Download: http://www.excelforum.com/attachment.php?postid=4177
+-------------------------------------------------------------------