1. We have added a Gift Upgrades feature that allows you to gift an account upgrade to another member, just in time for the holiday season. You can see the gift option when going to the Account Upgrades screen, or on any user profile screen.
    Dismiss Notice

Need help with Excel/VBA

Discussion in 'Computer Talk' started by Olav, Jun 16, 2012.

  1. Olav

    Olav Ah-Ha!

    Joined:
    Oct 21, 2005
    Messages:
    875
    Hello,

    I have a list like this:

    Code:
    ID	X	Y	Z
    K01	1448	1270	33
    K02	1778	1820	18
    K03	1301	1098	30
    K04	1730	1899	29
    K05	1993	1410	13
    K06	1947	1796	10
    K07	1662	1431	40
    K08	1177	1508	39
    ...

    I want to create a .xls file for each of the IDs/rows. I also need the information in the XYZ columns to be copied over to the new file (in specific cells, e.g. cell A1, C3, C4).

    I guess this can be easily done with VBA, but I have no knowledge of it. And I don't have the time atm to learn it. Could anyone direct me to a site where I could find scripts dealing with this problem? Or maybe one of you can write it in 5 minutes?? ;)
     
  2. ainwood

    ainwood Consultant. Administrator

    Joined:
    Oct 5, 2001
    Messages:
    30,068
    Is the list currently in a text file? You could probably just open it in excel and if would put it in the cells for you. Otherwise I could write the vba quickly... But depends on the source data format.
     
  3. Olav

    Olav Ah-Ha!

    Joined:
    Oct 21, 2005
    Messages:
    875
    The list is in excel. I've figured out a way to collect the data from the list into another spreadsheet, however it requires me to manually save the file with correct filename. And when the list has several hundred entries, I really want to skip those manual operations for each file.

    If you have the time to write the vba, I would greatly appreciate it.
     
  4. ainwood

    ainwood Consultant. Administrator

    Joined:
    Oct 5, 2001
    Messages:
    30,068
    Email it to me: cfcgotm[at]gmail.com, along with detailed instructions of what you want.
     

Share This Page