I cant figure out how to copy down the formula into all rows in the data sheet. The problem area is enclosed in **.
Thank you in advance for you assistance.Please Login or Register to view this content.
I cant figure out how to copy down the formula into all rows in the data sheet. The problem area is enclosed in **.
Thank you in advance for you assistance.Please Login or Register to view this content.
Attach a sample file with the formula and instructions
If solved remember to mark Thread as solved
This is just an example... I only left the part of the code that I'm referring to.
I asked for formulas, not code, I can not understand the formulas from your code, put formulas in the sheet, I'll translate to code
The formula is:
Formula:Please Login or Register to view this content.
Which is saying: AND(i<>"", i>=i8) *if this formula holds true, then the cell in column i9 will show TRUE, otherwise it will show FALSE.
I think I need to use the .filldown property, but I'm not sure how to define the range with a variable.
Last edited by Gard5096; 12-21-2012 at 11:38 AM.
formula is in G2
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks