1st. I need this right NOW!
2nd. If you haven't looked at the WB and have an idea what I am talking about don't waste our time.
On WB attached. Let's start with the WS "All Weeks". The rows contain the data required for another project. The rows always remained aligned. You can see that Column O (AD) has no data. This is what I need populated in that column. I need the data from other WS (Located in the names text boxes). These text boxes are updated regularly.
The following VBA Script functions when located on the same WS (see WS CA Macro). As an example of what I was think I will poorly rewrite it. It doesn't need to be that exactly, whatever you think is best that accomplishes my needs. It must always remain in the row even when resorted.
VBA that function when on the same WS.
Range("A1").Value = [login to view URL]("Text Box 1").Text
VBA on WS CA (WORKS)
Range("U9").Value = [login to view URL]("CA_AD").Text
VBA I had in mind but am flexible
Range("P2").Value = [login to view URL](=IF(C2=VT,CA!"CA_AD",if =vaWSVA).Text
I won't pay more than $50 unless you explain why
9 freelancers are bidding on average ₹4679 for this job
Hello ! My experience with vba is more than 10 years. From the description it is not clear what is meant. Can You upload example of xls file - that would explain a lot. Thank You. Regards, Alexei.