Hi Guys,
hope you can help me with this project.
Depending on "Current User" Value, use VBA Loops to fill values X to Y starting cell A1 such that each column has only 10 cells filled. The output should be as per above sample
Values of X and Y will be based on the User's level. Please below table.
Your "User Level" reference is cell C25.value(drop down). Link and call your macro everytime c25.value changes
Option explicit is a must.
**Code must be placed on "Sheet1"
Hope to hear from you. Thank you in advance.
Bookmarks