I need to copy the visible rows(filtered lists) in sheet "Raw Data" (A:CI) excluding headers and paste the same in sheet "Filtered" after the headers
I need to copy the visible rows(filtered lists) in sheet "Raw Data" (A:CI) excluding headers and paste the same in sheet "Filtered" after the headers
or paste it in the next blank cell since i will be pasting another set of filtered data after
Last edited by FLani; 04-11-2013 at 03:50 AM.
Would this be useful for you?
http://www.excelforum.com/excel-tips...-formulas.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
No. I need to copy the cells and paste it as values in Filtered sheet. There are two runs, the second i have to append to the existing data in the filtered sheet after the 1st run
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks