I have a large spreadsheet with around 20 sheets which need to be merged into a single master sheet. The columns on the sheets are all the same but a reference column would need to be added to show which sheet the data has come from. There is also a column on each sheet which displays the parent company and the brands within the parent company by the amounts the text is indented so I need to find a way to split this up into a parent company and brands column using the indentation. I can't use VBA to do this and have been told to use INDIRECT for this. Would greatly appreciate any help even if its just an example of how to do this for a few sheets and I can replicate it for the rest of the sheets. The deadline for this is tomorrow morning so would need help in the next few hours. Believe this should only take an hour or two.
12 freelancers estão ofertando em média £13/hora para esse trabalho
Hi Briana. Could you provide me with some samples? I can do it in python with an external script which is fast and simple with indirect. Contact me so we could talk better about it. Thanks
Hi! I am very familiar with most of the Excel functions, especially indirect! I'm sure can give you a hand on your project! Looking forward to your response! Thao