tomfolinsbee
asked on
Modify script for transforming Excel spreadsheet to database format
This is follow up question to solution posted by faustulus:
https://www.experts-exchange.com/questions/28249913/Script-to-Transform-Excel-spreadsheet-into-tables.html?anchorAnswerId=39545380#a39545380
I would like to modify the script in this spreadsheet to take into account a new column (PartID) inserted into the Source sheet.
This PartID should be used in the other three output sheets, in the same way that the part name.
Thank you!
https://www.experts-exchange.com/questions/28249913/Script-to-Transform-Excel-spreadsheet-into-tables.html?anchorAnswerId=39545380#a39545380
I would like to modify the script in this spreadsheet to take into account a new column (PartID) inserted into the Source sheet.
This PartID should be used in the other three output sheets, in the same way that the part name.
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear Faustulus, Many thanks for the excellent script. It worked perfectly first time on the full dataset. Apologies for the late reply, got tied up with other projects. Again, thank you!
ASKER
Faustulus, could I trouble you to make one more change? In the script, I think there is some code that replaces hard returns within a cell with a " - ". Is it possible to modify the script so that the part name remains exactly the same as the source document?
p.s. The reformatting looks much better, but I'm going to ask my colleague to clean up his source file instead.
p.s.s. Can I just comment out the part of the script that substitutes the hard return for " - "?
Thanks!
p.s. The reformatting looks much better, but I'm going to ask my colleague to clean up his source file instead.
p.s.s. Can I just comment out the part of the script that substitutes the hard return for " - "?
Thanks!
If there is no return there will be no effect.
If there is a return there will be a problem if it goes untreated.
I can remove the code that does the substitution, but the effect is unlikely to be an improvement.
If there is a return there will be a problem if it goes untreated.
I can remove the code that does the substitution, but the effect is unlikely to be an improvement.
ASKER
EXX-131003-Re-format-Database-TF.xlsm