+ Reply to Thread
Results 1 to 2 of 2

quickly modifying a table

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    7

    Question quickly modifying a table

    Hello, I am trying to create a macro or a formula that will allow me to quickly modify a large table of data. I basically need a summary that includes the customer name, and the total from the formula at the end that particular section of the report that shows total dollars quoted to that customer. I would consider doing this by hand, but the report is just about 500 pages long and I was hoping to automate it somehow. I have attached a copy of a sample of the report for reference. Any help would be much appreciated!

    -Matt

    week end report detailed.xlsx

  2. #2
    Registered User
    Join Date
    04-03-2012
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: quickly modifying a table

    I'm just going to bump this. I've pretty much figured out what I need the macro to do. It just needs to first recognize which cells in column a (customer) have a name in them, then pair that value to next formula that occurs in coulmn J (quote total). These formulas contain the totals for each customer. Now I have tried cuting the outline back so only those values are viewable, but I cannot seem to be able to select only those cells, because when I try, it selects all of the cells in between. Any thoughts?

+ 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