+ Reply to Thread
Results 1 to 2 of 2

Macro to fill out a log sheet

  1. #1
    Registered User
    Join Date
    11-11-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    4

    Macro to fill out a log sheet

    I'm looking for a macro that will allow me to update a log sheet with the click of a button, this will be in another workbook. It will need to open the log sheet, pull data from the other sheet into the next available row, and then close the sheet again.

    Any help would be hugely appreciated! Please tell me what you need to know.

    The log sheet file path is: file:///L:\General%20Data\Test%20Log.xls

    The Log sheet has the following headings and I have written the cell in the main sheet that it needs to copy it from:
    Client - C2
    Project - C10
    Engineer - E5
    Sales - E3
    Quote number - D5
    Value - I24
    gross Margin - L1
    net Margin - M1

  2. #2
    Forum Contributor
    Join Date
    05-02-2015
    Location
    calgary alberta
    MS-Off Ver
    2012
    Posts
    203

    Re: Macro to fill out a log sheet

    If I may make a suggestion you will get a lot more help if you attach a sample of your workbook to the posting instead of a link, this way we can download and edit it for you

+ 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. Macro to fill 3 columns in one sheet with data from 3 cells in another sheet
    By programct in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-30-2013, 02:44 PM
  2. Macro to automatically fill in a sheet form multiple workbooks
    By jimmyd270682 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-30-2013, 02:39 PM
  3. Macro fill cell based on value from another sheet - columns change
    By tcy1227 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-02-2012, 07:01 AM
  4. Replies: 1
    Last Post: 07-30-2012, 02:35 PM
  5. Populate Fill down on a sheet using a macro
    By thequiff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 11:52 AM

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