I have a column with a function in the top row. I want VBA to read that function and copy it down to the next cell as long as there is something in the cell 5 columns to the left.
Any suggestions? Here is the function I need copied down. =VLOOKUP(Q5,References!$B$2:$C$70,2,0)
you could use something like this
Please Login or Register to view this content.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
So you are saying that I need to specify 3 different rows? What about the columns?
sorry in my second 2 comments it should be column, not row, typosee bellow:
Please Login or Register to view this content.
Sheesh! I cant get anything to work right. Im trying to modify someone elses code and I am unfamiliar with it. This is what he had but it skips every other row. I tried yours but I must be doing something wrong because it wont work right.
Please Login or Register to view this content.
If you can answer these 3, i can modify the code for you
-what column do you want the formula in?
-what column do you want to check to make sure is populated?
-what row do you want to start on?
AV is the column that needs formulas copied down
Check Column C to see if it is populated
Start on row 3
Try this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks