Copy columns (with formatting) based on data in another sheet

Hello,

I'm working on an Excel file containing two sheets, on the second sheet called 'CSV' there's a value between 7 and 15 in cell A1. In the first sheet is a table containing conditional formatting.

What I want to do, is to copy two specific columns in the first sheet, including the conditional formatting (columns B and C), an 'x' amount of times to the right; 'x' being the value from Sheet2!A1. Also, in the first row of these two columns, there's now the text "R1" and "p1", but for every copy of the columns, I would like to automatically change it into "R2" and "p2", "R3" and "p3", etcetera.

I know my way around Excel formulas, but I've never used macro's or so yet. I couldn't find any way to do this with simple formulas only, so I hope that someone could help me out here.

Kind regards,

jcfransen

I forgot to add one thing: in the second sheet 'CSV', there is also other data, that is imported into column B of the first sheet, but also in all the recently copied columns. Would this even be possible?