Get instant live expert help on I need help with excel variable cell reference
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I'm trying to create a macro. Within the macro, I'm trying to reference a range that is variable. I need help creating this variable range.
Solved by Z. H. in 28 mins
I'd like to reference to a different workbook, while keeping its sheet variable.
Solved by T. W. in 15 mins
On the Break-Even Analysis worksheet begin to create a one-variable data table by referencing the cell that calculates the total expenses in cell H4. In cell I4, reference the cell that calculates the gross revenue. In cell J4, reference the cell that calculates the net income. Apply custom formatting to cells H4:J4 so that the results of the referenced cells are hidden. Finish the one-variable data table to see how the expenses, revenue, and net income change when the total number of clients vary from 10 to 100.
Solved by D. Y. in 12 mins
On the Simulation worksheet, create a one-variable data table that will function as a predictive model by simulating 100 iterations. In cells B8:E8, reference the appropriate cells on the Model worksheet. These references will be hidden, using custom formatting. Create a one-variable data table, using cell L1 as the column input cell.
Solved by I. S. in 17 mins
VBA HELP: For Each Next or Loop addition to my code: I have a variable, named C, that's referencing a cell value. After running the code, I want that reference to move down 1 row, select that new cell value, place it into my C variable and run macro again. Repeat until all values in range have been completed.
Solved by T. S. in 26 mins