VBA Help with Pasting and Inserting Cells Based

Hello,
Having a hard time figuring out the VBA code to accomplish the following.

-Copy/Paste/Move Rows Down(to avoid overwriting) from cells A1-A7 from Sheet2 to Sheet1 column A in each blank cell above cells that begin with "1.".

Constants besides "1.":
1. Cell count from Sheet2 will always be same cells.
2. All data will be in column A in both Sheet1 and Sheet2.

Any help or starting point would be appreciated.

Not clear to me...

Please Login or Register  to view this content.

Originally Posted by jindon

Not clear to me...

Please Login or Register  to view this content.

Hello,
I apologize if I wasn't clear. I did try to with portions of the code but no luck.
I added a sheet that shows the goal I am trying to reach.

1)
Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.

2) Is this how you wanted?

Please Login or Register  to view this content.

That works perfect jindon. Thank you!

You welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.