+ Reply to Thread
Results 1 to 1 of 1

Help setting up worktook to save as/clear contents and increase cell number

  1. #1
    Registered User
    Join Date
    12-23-2020
    Location
    California
    MS-Off Ver
    2016
    Posts
    1

    Help setting up worktook to save as/clear contents and increase cell number

    Hello,

    I have an excel file with our work order sheets in it.

    I would like to have a button that when pressed either does a save as function, clears the contents of certain cells then increases the work order number by 1 OR
    Copies the current workbook into a new one as saves the new one, clears the contents of the original and increases the work order number.

    There will be at least 2-3 people working with this file at any one time, so I want to make sure that the original stays clear and it keeping the work order number in sequence whenever a new order is saved.

    I hope this makes sense.

    I have attached the file as well.
    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)

Similar Threads

  1. [SOLVED] Clear contents of each sheet and save
    By Roadhouse in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-26-2018, 02:07 PM
  2. [SOLVED] Needing VBA code to clear contents of cell when the contents of another cell is cleared
    By jeh0714 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2016, 03:49 PM
  3. Clear merged cell contents in comand button(clear all)
    By mohan_984 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-25-2015, 10:39 AM
  4. [SOLVED] Clear contents based on contents of another cell
    By Katrina DTE in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2013, 02:44 PM
  5. Replies: 0
    Last Post: 11-06-2012, 11:16 AM
  6. Increase cell by 1, print as PDF and save PDF with that cell number as file name
    By eldred100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2012, 09:39 AM
  7. [SOLVED] Clear Cell Contents based on Number Format
    By lloydgodin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2012, 04:55 PM

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