Auto-Fill values

[Saher Naji]

Hello

Thanks in advance,

I tried to crate a formula, but the problem I have to make the formulas fixed by $ symbol, this will cost me a long time

What I'm looking for is a formula or a macro to do this thing automatically each time, because I have hundreds of rows, and the number of boxes (columns) is not fixed, some times I have 50 boxes or more.

Check the attached screenshot please,

Best.

 

[alansidman]

No pay. Likes are all we can have here.

 

[Saher Naji]

No pay. Likes are all we can have here.

I hoped that I can do something more likes, really thank you
your work like a magic, is there a book can you advice me to read it to learn VBA? I'm a fast learner, and it's important for me

 

[alansidman]

Check out the book section of MrE. He has lots of good material

 

[Saher Naji]

Hello Alan,
I posted a new questions, it's similar to this one which you graciously helped me and solved it,
this is the link:

Auto-Fill values (2)

Hello O great and smart people actually I posted a similar thread before some days, and Mr. @alansidman graciously did a great help and his code is working very well, 100% and this is the post link for the solved problem: https://www.mrexcel.com/board/threads/auto-fill-values.1133259/page-2...

www.mrexcel.com

Best,

 

[alansidman]

Pretty busy with life right now. Will give this consideration over the next couple of days if those priorities ease up and allow me time. In the meantime, hopefully someone else will step in with a solution.

 

[Saher Naji]

Pretty busy with life right now. Will give this consideration over the next couple of days if those priorities ease up and allow me time. In the meantime, hopefully someone else will step in with a solution.

Sure, thanks a lot