rcmurphy@mac.com

Importing sub-summary worksheet

Discussion created by rcmurphy@mac.com on Dec 7, 2015
Latest reply on Dec 8, 2015 by mikebeargie

Hi-- I can't figure out how to write a script that imports an Excel worksheet with a sub summary layout while filling in missing data. I would like to import the data and fill in the ID numbers in their associated row (i.e. copy 78900 up to 987650, then copy 987650 up to 543980, etc). It's a large excel worksheet with lots of codes associated with IDs, so I'd prefer to not do it in Excel.


Any help is greatly appreciated


It looks like this:


ID                    CODE

78900                    54

                              67

                              98

                              Y6

987650                  96

                              90

                              67

543980                  25

                              89

                              B6 

Outcomes