+ Reply to Thread
Results 1 to 2 of 2

command button

  1. #1
    Registered User
    Join Date
    03-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    1

    command button

    i want to create a save button in sheet 1, on clicking the same the data entered in the particluar cells of sheet 1 should get saved in sheet 2 in given format

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: command button

    You don't provide enough information for anyone to be helpful.

    Why not start by using the built-in Macro Recorder?
    Turn on the macro recorder, go through the steps of copying and pasting your cells from sheet1 to sheets and applying the formats you want.
    Post the code and/or workbook for help in refining the code.

    To get precise help you need to be more explicit: which cells are to be copied, where do they need to be copied to, what is the format required, etc.

    By the way, "Command Button" as a thread title is not descriptive of your thread.
    Please edit your thread title to something that actually defines your need, like: Copy cells to other sheets and apply specific formatting
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ 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