+ Reply to Thread
Results 1 to 5 of 5

Creating an updated work completed sheet?

  1. #1
    Registered User
    Join Date
    07-18-2006
    Posts
    73

    Creating an updated work completed sheet?

    Everyday I create daily reports. They now want me to create a sheet that is constantly updated with a list of the reports I've done including a little information about it. I thought it would be great if at the end of my macro each of my reports all open up a "Work Completed File" go down to the next line and then have it fill in the information across that line based on what the report was on.

    I just wanted to know how I would write VBA code that would find the next blank line and how I would write code to fill in 4 columns across based on cells of my report (everything is all excel). Then everytime I ran something, at the end of it it would do the same thing.

    Can someone help me on that? I'm not sure how to make it find the next empty line and then allow me to fill in that line across 4 different cells in that row.
    Thanks!

    ~J

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071
    Hi,

    It looks feasible ...

    To Select Range from A1 to "whatever is last line in the Column"
    Range("A1:A" & Range("A65536").End(xlUp).Row).Select

    As far as inputing four cells, let me know what is it you are looking for ...

    HTH
    Cheers
    Carim

  3. #3
    Registered User
    Join Date
    07-18-2006
    Posts
    73
    I'm a little confused. I wanted a "Work Completed" spreadsheet to open during the macro and have it take the name of the excel spreadsheet I had completed to have its name on the next available line in column A, then in the cell to the immediate right, have the date filled in, which can also be found in a cell of my completed report. Then the next time someone calls on this macro it will do the same thing.

    Basically I want to attach this to the daily macros I run so it will keep a record of the work I have completed with the dates that I have in the completed sheets.

    ~J

  4. #4
    Forum Contributor
    Join Date
    11-11-2005
    Posts
    267
    Nba,

    Can you systematically break down, in lucid terms, what you want the code to do?
    HTH
    Myles

    ...constantly looking for the smoother pebble while the whole ocean of truth lies before me.

  5. #5
    Registered User
    Join Date
    07-18-2006
    Posts
    73
    I have different macros setup, so when I press the main button it runs a query, takes the results and makes a graph out of it, it does this with a few different reports and saves them as files according to different criteria. The files are then automatically setup to be attached to a new outlook message to be sent out. Basically I wanted to know if I could add code so that after a report is created, a file called "Work Completed" is opened, it finds the first open row and then fills it in with info from the report I created.

    There are cells I have in the report that have information that I want to be linked to the Work Completed sheet such as filename, date, query parameters. Basically I want the Work Completed sheet to have cells that are linked to fields in the reports after they are created. I want to be able to run a report and then the Work Completed file opens, finds information in certain cells of the report, and either links or pastes it across the first open row of the Work Completed file. Then this would automatically update the list of work that is done everytime a report is made.

    I'm sorry, I hope that makes it clearer.

    ~J

+ 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