Nothing built into excel allows you to do this. If you're lucky, maybe you could sort the destination range so that the area to paste is contiguous and you could paste normally into that area???? NeedToKnow wrote: I have a file A which has 1000 rows and 7 columns. I have another file B which has 500 rows and 14 columns. I need to sort file A and copy from sorted file B some information
I just tried, and everything iappears to be right, except the columns are all reverted back to same width each instead of the way I changed them to different widths. Next???? You've been very helpful and I hesitate to keep asking, but if you do come up with anything, please email me at sandy@embarqmail.com. Thanks. "NeedToKnow" wrote: When you have copied sheet to new book, you
Thank you again! This site has been a huge help in last 2 months for me. Life would be sometimes much easier if I would be making files just for my own use. "Dave Peterson" kirjoitti: If you want to always overwrite your file, you could use: application.displayalerts = false 'your code to save application.displayalerts = true But if you just want to check for an error
Uh oh - back to the drawing board - I was able to send the single worksheet, but it does not carry the formatting, so columns, etc., were all out of whack and it would take me too much work to recreate the original formatting in the new workbook for emailing worksheet daily. So, Any other suggestions? "NeedToKnow" wrote: Would it work if you right-click sheet with mouse, select move
OK, I did as you said - highlighted the worksheet (click upper left corner), right click worksheet, copy, create new workbook, paste, and email (to myself for testing) - I received the one worksheet and just closed the new workbook without naming or saving. I think this will work. Thanks for the help. "NeedToKnow" wrote: Would it work if you right-click sheet with mouse, select move