Hi All, been watching from the sideline for a while and picked up some great formulas and VBA's. I'm struggling with the following:-
I have a workbook that requires me to copy complete rows of information from a sheet called "Variations" where row F: contains "Contract Instruction". I'd like this to be copied to a sheet called "Variation Account" including the headers on the original sheet. Hopefully this could be automated so when a new item is added the information is added to the Variation Account sheet.
Any help from you fantastic people would be a great help.
I have a workbook that requires me to copy complete rows of information from a sheet called "Variations" where row F: contains "Contract Instruction". I'd like this to be copied to a sheet called "Variation Account" including the headers on the original sheet. Hopefully this could be automated so when a new item is added the information is added to the Variation Account sheet.
Any help from you fantastic people would be a great help.