Consulting

Results 1 to 2 of 2

Thread: Master file and renaming it each morning.

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Nov 2022
    Posts
    1
    Location

    Master file and renaming it each morning.

    Question

    I have a master excel file that every morning gets opened and then a save as is done named as the relevant day IE 10 and throughout the day the excel sheet is compiled with the date for the day to each machine being we have 40 machines and every morning having to transfer the last line of data to the new file takes time.

    So, the question is, is it possible to somehow take the last line of data from the newly named sheet for each machine and place it in to the master document in the first line to the relevant machine this will save a lot of time of having to input the data manually then I can just do a save as and start again?

    I hope this makes sense of what am trying to ask.

  2. #2
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,967
    Location
    Create a macro to saves the last line of data into a new book at close of each day and save as " next days date", should be simple enough.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

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