Aaron Greene
asked on
Copy and Paste Filtered Rows from Linked SQL table
I have an excel worksheet that has an linked table to a SQL view. I would like to filter the table based on a date and then copy the filtered rows into a range on another worksheet.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
to select just the Current Region, make sure your active cell in in there, and press Ctrl-Shift *
if you Paste Values a lot, it is worth memorizing a keyboard shortcut. Here is the one I like best:
Ctrl-Alt-V, V, Enter
You can also use
Alt-E, S, V, Enter