Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and paste when in fliter
Hi,
When I use fliter, how can I copy and paste the data in another column? For example: When I filter column A with "Texas", I want to copy the data in column B into column C. However, as column A is in fliter, I can't do this. Can anyone have an idea to solve it? Thanks. Column A Column B Column C 1 Texas A 3 Texas B 5 Texas D 6 Texas F |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and paste when in fliter
Hi,
I think you will need to use a macro. Sub Macro1() Dim cell As Range Selection.SpecialCells(xlCellTypeVisible).Select For Each cell In Selection cell.Offset(0, 1) = cell Next cell End Sub to use this you select the filter range, say B2:B10 and run the macro. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "lalann" wrote: Hi, When I use fliter, how can I copy and paste the data in another column? For example: When I filter column A with "Texas", I want to copy the data in column B into column C. However, as column A is in fliter, I can't do this. Can anyone have an idea to solve it? Thanks. Column A Column B Column C 1 Texas A 3 Texas B 5 Texas D 6 Texas F |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and paste when in fliter
Thanks. Hope that the new excel has this function without the use of a macro.
I believe that a lot of people will use this function pretty often. "Shane Devenshire" wrote: Hi, I think you will need to use a macro. Sub Macro1() Dim cell As Range Selection.SpecialCells(xlCellTypeVisible).Select For Each cell In Selection cell.Offset(0, 1) = cell Next cell End Sub to use this you select the filter range, say B2:B10 and run the macro. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "lalann" wrote: Hi, When I use fliter, how can I copy and paste the data in another column? For example: When I filter column A with "Texas", I want to copy the data in column B into column C. However, as column A is in fliter, I can't do this. Can anyone have an idea to solve it? Thanks. Column A Column B Column C 1 Texas A 3 Texas B 5 Texas D 6 Texas F |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Ms excel 2007 (Fliter and merge issue) | Setting up and Configuration of Excel | |||
Sum after Filter, Count after Fliter | Excel Worksheet Functions | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
i can not fliter unique records | Excel Worksheet Functions |