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