Microsoft Office Forums - View Single Post - Repeat Function By Changing One Variable

Thread: Repeat Function By Changing One Variable

View Single Post

Old

09-28-2017, 05:03 PM

abbani

abbani is offline

abbani uses Windows 7 32bit

Windows 7 32bit abbani uses Office 2010 32bit

abbani uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Feb 2016

Posts: 11

abbani is on a distinguished road

Default

Repeat Function By Changing One Variable

I have a function
(='C:\Trip\[Job1.xlsx]sheet2'!$M$2)
I would like to repeat this function in around a 1000 rows by increasing the value of the sheet
from Job1 to Job2, Job3, and so on
Please advice.
Thanks.

Reply With Quote