Hi
I am trying to set up a spreadsheet to carry out hierarchical imports, using macros to translate a flat file (ie my customer's own spreadsheet with one record per row including a lot of extra unneeded stuff) into an Actinic friendly hierarchical file with Custom Properties.
My biggest headache is trying to work out how to handle the Sections and Subsections. Some of the products are at section level and some at subsection level, so my current thoughts are that I should set up a second section-defining sheet holding Section description and image filenmae, and then use HLOOKUP or something similar to generate the Section rows. But I will also need to know whether I need to write End,Section once or twice depending on whether I am coming out of a Section or a Subsection. Arrggggh!
Can anyone advise on the best approach to this please?
Thanks, Dan
I am trying to set up a spreadsheet to carry out hierarchical imports, using macros to translate a flat file (ie my customer's own spreadsheet with one record per row including a lot of extra unneeded stuff) into an Actinic friendly hierarchical file with Custom Properties.
My biggest headache is trying to work out how to handle the Sections and Subsections. Some of the products are at section level and some at subsection level, so my current thoughts are that I should set up a second section-defining sheet holding Section description and image filenmae, and then use HLOOKUP or something similar to generate the Section rows. But I will also need to know whether I need to write End,Section once or twice depending on whether I am coming out of a Section or a Subsection. Arrggggh!
Can anyone advise on the best approach to this please?
Thanks, Dan
Comment