excellll.png I want to create a new column and bring the remaining cells to a new column everytime an ==== appears because it signifies a new day. I'd like to add this to an existing VBA code so that it can be done in one macro. How can I make column P and Q look like the table on the right?
Last edited by planjb; 07-22-2020 at 10:34 PM.
Try
Please Login or Register to view this content.
This works perfectly! Thank you! However, I am encountering a new problem now. I would like to have one macro/vba code that repeats this function for 4 separate sheets. I tried inserting this code into my current VBA code four times to run this for each sheet but it is giving me a "compile error: duplicate declaration in current scope." I tried changing the x and i variable for each time I want to repeat this function but that didn't work. Is there any way I can make one macro that repeats this code in four different sheets?
Need to see your code.
I was able to get it to repeat without error! Thank you for all your help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks