copy and paste validation/formulas

[danfullwood]

Hello,

I need a macro which will copy row 5 and copy it into the next available row.

Atatched is my spread sheet.

The row i need data to be pasted in is 29 on the "un-sourced" page.

I want data from row 5 to be copied into the next available row +1 and pasted only as validation and formulas (which doesn't say yes or no in column A too). Another problem is, i only want formulas to be copied from columns C and F


So to sum up, copy entire row 5 into next available row +1 and paste only as validation, then copy columns C and F and paste them into the same available row as Formulas!


New-Unsourced.xlsx.xlsm

Thank you!!

[tony h]

I might get a chance to look later but have you used the "record macro" to give you hints as to how to do it.

Use : view ... macros ... record macro

then do the manipulation of the worksheet

Then view ... macros ... stop recording

Then look in the VBA editor to see what you have done.

Note this does not produce perfect code but can often give you a lot of help