Master Formula (With no new knowledge, a more appropriate title is impossible)

enuro12 · 07-08-2011, 11:30 PM

So I think my problem with this is I don't know how to word what i want to do. I've tried indirect, address, substitute ect.

I have a basic Workbook that generates some SQL scripts. Its all very basic. Due to the number of bits of data created i want a master formula. So i can change the "master" and all the refrences to it will update.

Currently my formula looks like this:

Please Login or Register  to view this content.

Where bother d1 and d15 change. Another Example i use is

Please Login or Register  to view this content.

Right now i've got to update each row 1 at a time when i change the formula. With over 1500 rows affected its a huge pain.

**JBeaucaire** · 07-09-2011, 01:49 AM

Originally Posted by enuro12

Right now i've got to update each row 1 at a time when i change the formula. With over 1500 rows affected its a huge pain.

Why in the world do you need to do that? You change the formula in row 1, then you copy the cell down that column, the formula as you've presented it will adjust itself as you copy down.

enuro12 · 07-09-2011, 10:16 AM

And after i update the formula i'll have to copy them all again.

They're also not all in the same row. Example:

The formula's are in column D,E,F & on rows 20-27, then 47-54 ect ect ect

**arthurbr** · 07-09-2011, 12:46 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

enuro12 · 07-09-2011, 01:23 PM

I stated very clearly that i do not know what it is called that i want to do. I have also spent almost 5 hours searching google for the answer to my problem. Which is how i got here.

I read your forum rules... I stated my issue to the best of my knowledge. I came here because i need help, if i knew the answer i wouldn't be asking for it.

So the cookie cutter response is not needed... And i've also stated why the typical function of a basic formula will not work for my situation.

**royUK** · 07-09-2011, 01:51 PM

Well don't post then

banned · 07-09-2011, 02:13 PM

After a response like that i shouldn't be surprised you banned me.

I am entertained by the fact that posting a topic to get enough information to formulate the question results in a ban.

I suppose it is easier to click ban than challenge your minds... Bye

**royUK** · 07-09-2011, 02:38 PM

You obviously didn't agree with the Rules maybe you have trouble reading! It's no challenge to the mind to see that you can't even use a basic formula correctly