Repeat Function By Changing One Variable

		Microsoft Office Forums > Microsoft Excel > Excel
Repeat Function By Changing One Variable

FAQ

Thread Tools

Display Modes

09-28-2017, 05:03 PM

abbani

Windows 7 32bit Repeat Function By Changing One Variable

Office 2010 32bit

Novice

Join Date: Feb 2016

Posts: 11

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.

Tags

function auto complete

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable	shimulsiddiquee	Excel	1	05-16-2017 07:39 AM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Can a function or sub be called using a variable name?	omahadivision	Excel Programming	18	12-05-2013 08:14 PM
Repeat formula 5 times and repeat?	Jenny345	Excel	4	06-14-2013 04:37 PM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:38 AM.