+ Reply to Thread
Results 1 to 2 of 2

A tough one! line up vertically/horizontally through data

  1. #1
    Registered User
    Join Date
    12-25-2004
    Posts
    61

    A tough one! line up vertically/horizontally through data

    *sigh* Ok, I have no clue if this is even possible.

    Ok, I have about 1500 Excel workbooks that I need to go through. I need to copy the content of cell E13 in sheet "Summary - Page 1". and paste this figure into my open workbook (levels.xls), accordingly to the account number and month the figure is from. In the 1500 workbooks, the account number is always cell C2 in sheet "Summary - Page 1", and the date is in J2 (same worksheet). SO this is what we got for the workbooks

    C2 = Account Number (5 digits)
    J2 = Date (in m/d/yyyy format)...altho all I want from it is the MONTH name
    E13 = Dollar Figure
    All in sheet "Summary - Page 1"

    My open workbook I have set up like this...
    A B C E
    1 Account | January | February | March | etc.
    2 11111 20,598.21
    3 11222 25,458.25 69,256.25
    4 12569
    5 23691

    Now I can manually select the file that I want to open. (Application.GetOpenFilename)...

    But I want the code to see the content of C2, so it could align itself correctly vertically in levels.xls.......Then see the content of J2, and align itself horizontally in levels.xls....and then copy over E13 into where it falls

    Thanks

  2. #2
    Registered User
    Join Date
    12-25-2004
    Posts
    61
    *bump*

    Anyone?

+ 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