this is driving me mad and im sure its simple.
i have 2 sheets in 1 workbook. if column F on sheet 1 contains the word "YES" i need it to copy and paste the data from columns A&B in that row, to columns C&D on sheet 2.
any ideas what formula i need??
Try this, click on the information to be copied, if you want to copy A&B, click A, hold control and click B, the two will be highlighted, then right click on your mouse, select COPY, then click sheet 2, now click once on C, right click and select the first pasting option, it is done.