+ Reply to Thread
Results 1 to 1 of 1

Macro that will copy cells to another area & print active page (not sheet)

Hybrid View

  1. #1
    Registered User
    Join Date
    03-05-2012
    Location
    Chicago
    MS-Off Ver
    2007
    Posts
    25

    Macro that will copy cells to another area & print active page (not sheet)

    Recipes.xlsm

    The above file is going to be a database for all the recipes for a client. There will be multiple sheets for different categories. I want to make adding a new recipe as easy as possible for the user. I'm looking for a macro that will do the following: When the user clicks "New Recipe" the template shown will add itself to the bottom of all of the existing recipes on the selected sheet. Is this plausible?

    I'm also looking for a way to accumulate all recipe names from a sheet into a single column (preferably automatically with a formula or macro). How would I go about doing this?

    Lastly, I want to assign a macro to the print button that will print the page that the button resides on, or even prints the page in which the cursor (or selected cell) resides in. How can I do this?

    Thanks in advance!
    Last edited by Cyali; 05-10-2012 at 10:17 PM.

+ 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