Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Array and formula in different worksheet



I appreciate have your help, how or if possible  to use some data in a worksheet ( each column has a set of data) and use then in different worksheet which include some formulas and save the result in some cells and then go to the next column, 

Or each Column can have its macro to use the mentioned worksheets and their formulas,




Hello 76PI and welcome to the forum,

What you have described certainly sounds possible.
If you could upload a sample file (with generic data) so we can see exactly what you are trying to achieve, it will make it easier to provide a useful solution. Just use the "Add Files" button to upload a file to your post.
WillieD24 (rep: 382) Aug 28, '22 at 10:52 pm
@76PI - I agree with Willie but suggest you explain (in your question) what you mean by "go to the next column"- do you mean just select the adjacent cell in the column to the right or iterate through populated column (processing data from the other worksheet)?

@Willie - I'll leave this one for you to answer
John_Ru (rep: 5722) Aug 29, '22 at 4:51 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login