Hello everyone,

This is more of an advice query than anything else. I have an Excel template that has multiple sheets for different timepoints i.e. IND D28 Pre, IND D28 Post, GM D28 pre, GM D28 post and this continues for many sheets. What I'd ideally like to do is have a macro that looks at each sheet name and if the first 5/6 characters match then new worksheets are created putting each column side by side i.e. column A from IND D28 Pre gets copied into the new worksheet and column A from IND D28 Post gets copied into column B in the new sheet and so on. Thus combining data from each pair of worksheets.

I tried doing this by creating a template that simply has extra sheets and has a simply look up for each sheet/column. This is a pain because there could be additional timepoints and sheets and the formulae have to be copied over etc. and it does really work it terms of saving time.

Any advice would be greatly appreciated

ECGs.xlsm