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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks