Hi,
I would appreciate help on the following. I've attached an XLS - I'm trying to learn this concept to use for a plethora of other macros
The two columns I want to populate are M and N
My mindset is to start with C3... IF(C3>0,offset(c3,-1,0),[if its = 0 then it should just move to D3 and repeat until the cell value >0])
Then once there's an answer it will begin looping to the next row 4 and repeat the process until column B is empty
Really appreciate it. Thank you.
VBA_1.xlsx
Hi, AMJ,
what shall go into Columns M and N? If you attach a sample it would be nice to see the data before and after to know what to code for.
Edit:
maybe I figured put what you are after.
Ciao,
Please Login or Register to view this content.
Holger
Last edited by HaHoBe; 06-30-2014 at 12:09 AM. Reason: added code
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Holger, Thank you so much! This is exactly what I am looking for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks