vba looping

I'm still new to VBA, Took a long break and started studying C++, so now I'm all confused as to how to get this done in VBA. So here is an image of the file. I have my bills located on the same sheet Starting at B76:D100, B76,C76, and D76 are titles Date, Item, Amount The Date is a formula.. As...

So I have recorded a macro and I want to loop it but all it’s doing is just repeating the same code over and over again. I want it to run and move right a Colomn and run for all Colomns. To give more detail I just wrote a sumifs equation and I copy paste it to the next colomn chnage the cell and...

Hello everyone, I'm trying to retrieve values from websites and enter them into an excel table using VBA. Column A has URLs Column B C and D are where I want the info extracted to be stored The URL varies for every row so I'd like for the VBA to increment the range as it goes through. My code...

Hello, I have 2 tables: Table 1 = Original names & phone numbers Table 2 = New names & phone numbers I want to loop through each of the phone numbers in the original Table & ONLY if the number is 0 or empty, lookup the new value from Table 2. I've started with the below. Sorry, I'm a...

<TBODY> Data_Tbl</SPAN></SPAN> Staff_ID</SPAN></SPAN> Department 1</SPAN></SPAN> Department 2</SPAN></SPAN> Department 3</SPAN></SPAN> City</SPAN></SPAN> Date Hired</SPAN></SPAN> Grade</SPAN></SPAN> Hotspot Level</SPAN></SPAN> ID1</SPAN> Marketing</SPAN> Analytics</SPAN> Core...

Hello - I'm attempting to convert column data to row data. I currently have 16 columns and I would like to shrink this down to 6 columns. I have about 20 hours experience working with VBA and I'm stuck. Any guidance would be most appreciated. The current headers and layout is as follows...

Hi All, This should be easy but its not! I am wanting a VBA loop script. 1. which goes down column A and check if there are codes that are the same e.g below the first 4 are the same. 2. from this am wanting to create a new table which copies the code 000000HA once and then the 4 dates after...

Good Day Masters, As usual, I'll be needing your help. I am almost done with my code except that I received an error. To give you an overview, I have a sheet called "Template" which is hidden. Part of the code is to copy the "Template" sheet and rename it to "Schedule A" sheet. In the...

Hi Everyone, I need your expertise again. Below is only part of the code I'm trying to generate. What I'm trying to achieve is how to loop the ALoc1, ALoc2 etc. to assign the value fromCells(5 + i, 5) in the PPSheet. In default, ALoc1 is equal to SchedA.Range("B6") and I wanted to change...