Hi
I just want to cut and paste a spreadsheet with filters and sorting to another spreadsheet.
I think its possible to cut and paste selected cells?
thanks for your help
Hi
I just want to cut and paste a spreadsheet with filters and sorting to another spreadsheet.
I think its possible to cut and paste selected cells?
thanks for your help
Yes it is. Do you want to do it manually or through VBA?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Err, whatever is easiest please...
Select the filtered data, Copy it & paste. Only visible cells will be copied
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks Roy and yes, by cutting and pasting the data separately does work. I just thought there would be a better way to do it with all the data at one time...
You can do it via VBA. What are the ranges and where should they be copied?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks