Attached is a spreadsheet which has filtered values in sheet Table1. In trying to write some code that would put the word "Inbound" in one Cell and the three Outbound words in other cells, the code keeps throwing an error.
How can the code be written to place any visible text value, from a filtered table, into a cell and then place a second text value text value into a separate cell.
Cook09 Filter_Copy.xlsm
Excellent!!!!
Both the Pivot and the VBA are exactly what I needed. Not sure why there was an issue with the xlCellTypeVisible, but what you put together does work. Thanks for the Pivot...need to begin using this more. May have saved quite a bit of time.
Wish I could allot more points for two solutions...but....
You're always welcome! Glad I was able to provide solution as you expected.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
Please use below code:
Open in new window
Please find attached...