View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kativa kativa is offline
external usenet poster
 
Posts: 9
Default Copying filtered cells from a specific location

I have a filtered sheet, and I want to copy all visible cells to another
sheet starting from cell B4 (header cell) to column E. All headers from B to
E included, and the amount of visible rows varies. From the same sheet I also
need to copy the first visible cell from column A - header not included. Area
B4 to Esomething is copied to a different location on the other sheet than
the first filtered cell from column A.

I need more brain capacity!!! :=)