Hi everyone,
Long time Excel user, first time posting as it has been some time since I have done anything with VBA and I have pretty much forgotten everything I once knew.
I currently have a working macro that filters a list of copied data but because of some formatting issues in the source file, there is one particular piece of information that cannot be copied to the correct column and therefore filtered properly. The information I need once copied and filtered appears in Column A but I need it to appear in Column D, however this only applies if the cell above it contains the value "Manufacture name" as all other names in Column A don't have this problem. I am assuming I need some kind of loop as the phrase "Manufacture name" may appear more than once. I've tried using an IF formula within the VBA code and using some offset functions but am not getting anywhere.
Many thanks in advance for your help.
Long time Excel user, first time posting as it has been some time since I have done anything with VBA and I have pretty much forgotten everything I once knew.
I currently have a working macro that filters a list of copied data but because of some formatting issues in the source file, there is one particular piece of information that cannot be copied to the correct column and therefore filtered properly. The information I need once copied and filtered appears in Column A but I need it to appear in Column D, however this only applies if the cell above it contains the value "Manufacture name" as all other names in Column A don't have this problem. I am assuming I need some kind of loop as the phrase "Manufacture name" may appear more than once. I've tried using an IF formula within the VBA code and using some offset functions but am not getting anywhere.
Many thanks in advance for your help.