Call

Hallo ,
I have different Nrs of sheets, Example.. 1, 2,....... , then i referred these sheets to main sheet called Main .
I used Vlook and also tried Index/Match ,,, Everything works perfectly.....
The problem is whenever customer creates new sheet( in my case Example . 3), they have to go to Main sheet and they have to copy all formulas from up row & have to change the reference to 3 ,, again have to select areas for new reference and based on that again have to edit formula for all the columns.
In my case, we have many columns, so its tough for customer.. much manual work again.... Is thr any workaround?
Here is the Sample one,, but our sheet contains more than 10 columns
Kindly Note that we cant use one sheet for reference,,, we need different sheets. so i am confused here ..how to provide solution
Can anyone please help me out...
Answers
-
Hi @PYI
Since you're creating a completely new sheet you will also need to manually create new references to select this sheet in your formulas.
There isn't a way to have a formula automatically recognize when a new sheet is created and use it as a reference. (See: Edit a Reference Directly in your Formula)
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives