Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Fill formulas relative to cell with INDIRECT function
I finally got a more optimized version of the code. I've been avoiding the tables and lists because of the incidental possibility of sorting the information. The way that the information is put in doesn't allow for for sorting it back to the original format (at least that I'm familiar with)...- CLski
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Fill formulas relative to cell with INDIRECT function
I'm just having a little problem implementing the Index and Match combination now though. I don't get the need for the name for the ranges. (I already have unique names for the columns in the second row) My understanding of what you suggested is the following Range("C" & Row, "R" &...- CLski
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Fill formulas relative to cell with INDIRECT function
I have a macro that I currently use to expand a worksheet as needed depending the amount of data input on a previous page. Since the data on the previous page can and will be changed often I need to use an Indirect function (or something similar) in the cell formulas on another page to always...- CLski
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
