I am back again on this topic with more information and hopefully you can help.
When saving document 'New Quote Form' i want to run a macro that will copy data from sheet 'DataFeed' into sheet 'QuoteLog' of document 'QuoteLog'. All documents will be open when the macro is run.
The data i need transferred is all from New quote form into Quote log.
A2 to I2 , A3 to I3 , and then A4 to I4 into the next 3 empty rows in the quote log document, but i need it to skip out the d column, so no data is copy and pasted from the D column. The reason being is there is a formula in this box on the quote log document.
When the macro is run a second time i need the same data copied again, but then pasted into the next 3 empty rows.
So first save copies data into rows 2 3 and 4, next save it copies the same cells into the rows 5 6 and 7 etc.
I appreciate any help given.