Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected columns only
I have a code to filter out data rows based on the filter
criteria and copy the same to first blank row available in a sheet called summary. But now I dont want to copy all the rows. I want only filtered data of columns A, C, AD and BA columns. Any help is appreciated in this regard. Regards, Mac |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected columns only
-----Original Message----- I have a code to filter out data rows based on the filter criteria and copy the same to first blank row available in a sheet called summary. But now I dont want to copy all the rows. I want only filtered data of columns A, C, AD and BA columns. Any help is appreciated in this regard. Regards, Mac . Selection.SpecialCells(xlCellTypeVisible).Select will select only the visible cells in the current selection. These can then be pasted wherever you want them. It's the same effect as F5, Sepcial..., Visible Cells Only Cheers Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected columns only
Mark,
Thanks for your reply. But unfortunatly You misunderstood me. What I need is to copy only columns A, C, AD and BA columns. My sheet contains columns upto BK and all are visible after applying filter. Only rows not matching with the criteria gets hidden but all the columns are always visible. From those visible columns, I want to copy data only from those 4 columns. I hope this is now clear. Regards, Mac -----Original Message----- I have a code to filter out data rows based on the filter criteria and copy the same to first blank row available in a sheet called summary. But now I dont want to copy all the rows. I want only filtered data of columns A, C, AD and BA columns. Any help is appreciated in this regard. Regards, Mac . Selection.SpecialCells(xlCellTypeVisible).Selec t will select only the visible cells in the current selection. These can then be pasted wherever you want them. It's the same effect as F5, Sepcial..., Visible Cells Only Cheers Mark . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
copy only selected worksheets | Excel Discussion (Misc queries) | |||
Macro Help - Copy Selected Row | Excel Discussion (Misc queries) | |||
How I can copy / paste a selected cells to other columns in Excel | Excel Discussion (Misc queries) | |||
Copy selected lines | Excel Worksheet Functions |