+ Reply to Thread
Results 1 to 5 of 5

Need someone to edit Modify Macro's to work on entire work book

  1. #1
    Registered User
    Join Date
    01-21-2018
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    23

    Need someone to edit Modify Macro's to work on entire work book

    In the attached files, you will find a XLSM

    If you run the macro contain with in file you will see that it Imports the other raw data files and completes a range of functions
    Including: formatting, sorting, Clearing contents, renaming sheets and data headers....etc

    The files will need to be in C:\Raw Data (directory) the macro i made currently runs across all worksheets.

    Now with the help of another thread and the efforts on Both SinTek and Jindon and others who replied they created the folllowing macro's which summed and counted
    between the hours on the dataset i provided . in that post
    Here are the different macro's and approaches (BOTH worked very well)
    SinTek
    Please Login or Register  to view this content.
    ------------
    JinDon

    Please Login or Register  to view this content.
    If at all possible can either be modified to to work across data ranges of worksheets and workbook

    Attachments Xlsm and two .CSV files of raw Data ............ plus Zip file with complete dataset of CSV's
    Attached Files Attached Files
    Last edited by MarkKil; 01-24-2018 at 12:13 AM.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    3,191

    Re: Need someone to edit Modify Macro's to work on entire work book

    In the other threads you mentioned where Sintek and jindon helped you, did you notice that they had their code between code tags?
    Could you do the same in your post #1 here please.

  3. #3
    Registered User
    Join Date
    01-21-2018
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    23

    Re: Need someone to edit Modify Macro's to work on entire work book

    Sorry will do ... just been told now

    Newbie ... did not what code tags were until now ..
    cheers.......... will not make same mistake again

    Also makes the post much easier to read... once again thankyou

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    3,191

    Re: Need someone to edit Modify Macro's to work on entire work book

    Good job. Thanks

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    16,390

    Re: Need someone to edit Modify Macro's to work on entire work book


+ 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. vba to stop the macro to edit data in another work book and resume
    By karthikha in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-11-2018, 12:06 PM
  2. Current work book .xlsm convert to xlsx work book then mail
    By Vcare in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-26-2016, 09:47 AM
  3. macro to search entire work book and do Index match with 2 criteria
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2016, 11:52 AM
  4. (F9) VBA code to recalculate entire work-book
    By domgilberto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2016, 06:31 AM
  5. VBA Code for populating cells from one Work Book A to another Work Book with condition
    By ray.kanata in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-22-2015, 03:46 PM
  6. Assign List to Entire Work Book
    By rajeshp1983 in forum Excel General
    Replies: 1
    Last Post: 02-11-2011, 02:04 AM
  7. [SOLVED] Page Breaks for Entire Work Book
    By Steve in forum Excel General
    Replies: 2
    Last Post: 07-12-2005, 07:05 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