+ Reply to Thread
Results 1 to 3 of 3

Sheet to be pasted as values & format and save on desktop

  1. #1
    Forum Contributor
    Join Date
    10-28-2011
    Location
    Delhi
    MS-Off Ver
    Excel 2007
    Posts
    101

    Sheet to be pasted as values & format and save on desktop

    Hi,

    Attached file.
    Please help with a macro that would copy only the values and format to a new workbook, delete the Column B, save by clicking cursor on Quality; and then name the workbook and its sheet (deleting unused sheets) exactly like it is in attachment, save to desktop to make it ready to send to client.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Sheet to be pasted as values & format and save on desktop

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    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]

  3. #3
    Forum Contributor
    Join Date
    10-28-2011
    Location
    Delhi
    MS-Off Ver
    Excel 2007
    Posts
    101

    Re: Sheet to be pasted as values & format and save on desktop

    Quote Originally Posted by arlu1201 View Post
    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.



    You're right.
    Here is the attachment (Shrtcut: Ctrl+h)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1