VBA Copy Offset cells to another worksheet if Cell in Column B contains ''text''

Hi,

I want to do the following:


If cells in column B from Sheet 1 contains ''text'',

Copy Cells from column D and F from Sheet 1 - TO - Sheet 2 in columns C and E -



Thank you for your help.

I couldn't find a thread that matched what I was looking for so I am posting on this thread hoping someone sees it and can help me.

I am creating a spreadsheet that allows the user to buy an iMac

I have need the user to be able to enter their personal details / select their iMac / then have the accessories available for that iMac appear on the accessories page / create a final order showing their order including the product + accessories and all prices + total / then finally i need a receipt sheet which will allow me to print it off

I hope someone can help I am literally lost on how to fix this I have included the spreadsheet below if someone could look at it would be much appreciated
thanks David.RECENTICTCWK FEB 13TH.xlsm