Dublicate row based on value in column "C" and paste to bottom, changing date and divide amount, delete original row

[Konigsfeldt]

Hi all,

I have rows with budget amounts that are totals for a year, but want to split them into 4 rows in same sheet, changing the date from 01-01-20XX to 01-01, 01-04, 01-07 & 01-10 and furthermore divide the amount with 4. (So I can compare with actuals by quarter when pivoting)

The variable is in column "C", and says "Budget", which determines whether it should be quartered or not. Column "C" contains other values as well, such as "Actual" and "Opening post", and those should be skipped - but all budget rows should be quartered and pasted to the bottom (or anywhere in the dataset, as long as the entire dataset can be marked with crtl+shift+down). The sheet is called "Rawdata", and lastrow is column "AB".

The code should do the following (example with first budget row):

to:

Hope it makes sense!

Thanks for any help on this.

/Jacob

 

[Fluff]

Duplicate Dublicate row based on first 6 letters in Cell and paste to buttom, changing date and divide amount

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).