+ Reply to Thread
Results 1 to 5 of 5

macro to reformat a daily report that has different amounts of names and data on it daily

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question macro to reformat a daily report that has different amounts of names and data on it daily

    Hello. I pull a report daily with co workers names and performance day seperated with headers. When the report exports to excel it has the same errors every day. So every day I spend half an hour correcting the formating of the report. I've tried recording a macro to make the formatting changes since they are always the same but we have different employees there each day - sometimes there are 15 sometimes there are 25 so the reports are variable in length. There are specific identifiers before and after each of the teams in the report that I run. I'd appreciate greatly some suggestions on how to create a macro that will work to make the formatting changes regardless of how many people are listed on the report. Spreadhseet sample attached. The comments give more detail, the red font notes lines that need to be moved, the green font notes lines that have to be deleted after the data is lined up with the names. I'll seriously appreciate any insight anyone has! Thanks!
    Attached Files Attached Files
    Last edited by neoazra; 02-01-2014 at 01:35 AM. Reason: Adding Sample Spreadsheet

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: macro to reformat a daily report that has different amounts of names and data on it da

    it definitely doable, but a sample can pave the way

  3. #3
    Registered User
    Join Date
    01-30-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: macro to reformat a daily report that has different amounts of names and data on it da

    I thought about that after I posted. I'll upload a sample tomorrow morning

  4. #4
    Registered User
    Join Date
    01-30-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: macro to reformat a daily report that has different amounts of names and data on it da

    Sample attached to original question. Thanks!

  5. #5
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: macro to reformat a daily report that has different amounts of names and data on it da

    Since you said the errors were the same I wrote a routine expecting them

    it fills a copy of your output file,
    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. Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  2. Replies: 2
    Last Post: 09-28-2013, 02:40 AM
  3. [SOLVED] Creating Daily report with Macro
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-29-2012, 01:15 PM
  4. Replies: 2
    Last Post: 11-19-2010, 07:49 AM
  5. [SOLVED] How do I set up report linking data that changes on daily basis?
    By SrMarsia in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2005, 11: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