create macro to copy paste many rows at once

Hello, I am new to the forum and excited to learn of its existence! I am a long time Excel user for basic functions...never tried to create a macro until recently. I do not know VB

My situation is that I am updating 2 worksheets daily with date and financial values. I am repeating a set of 6 steps up to 50 times and its sinking my time and killing my energy! I tried creating a regular macro to do the job and quickly discovered its limitations.

Here are the steps:

1) copy entire row
2) right click row below
3) insert copied cells
4) paste special -- "values"
5) select entire row (from step 4)
6) From the "Fill color" pull down - select white fill

7) in another 10-30 rows - repeat 1-6

I would be eternally grateful for anyone who can help me create a macro to run these steps!

Thanks for your time....

Asaya Adea

Hi, and welcome to the forum.

You need to be a bit clearer about item 7.
How many rows do you want to leave before repeating steps 1-6? Simply saying in another 10-30 rows isn't very clear.

Then is it a consistent gap between the rows you want to operate on, or does this vary and you need to work out which is the first row in the next 'block'? In which case what's the rule?

Finally how many iterations do you need to make? Is this determined by the number of rows, or a fixed number.

Rgds