[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel getting parameter from Sheet1 to complete formula in sheet2 - switch different parameter in sheet2 from sheet1

Posted on 2014-08-27
4
Medium Priority
?
269 Views
Last Modified: 2014-08-27
Hi folks,

this time i hope anybody can help me with this excel problem. I've 2 sheets. Sheet1 with 9 different parameter to
complete a formula in sheet2. The data are transfered to sheet2 and the formula in sheet2 getting the parameter
from sheet2 to complete. Now i like to switch in Sheet2 from which line i'm getting the parameter in sheet1.
There are 9 different lines with parameter.
Pls see the example attached.

Thanks in advance.
mandy

in the example the formula only getting A2 or A5 or A8 or A11 or A15 or A18 or A21 (samaccoutname)
normally i've a lot of formula more with more parameters to create shared mailboxes
example.xlsx
0
Comment
Question by:Mandy_
  • 2
  • 2
4 Comments
 
LVL 54

Expert Comment

by:Rgonzo1971
ID: 40287363
Hi,

if in Sheet2 A1 you have the line parameter you could use in B2

=INDIRECT("sheet1!$A$"&A1)

Regards
0
 
LVL 2

Author Comment

by:Mandy_
ID: 40287400
Thank you but not resolve my problem.  The parameter in sheet1 are changed by customer. For example he likes
to order 9 different Shared mailboxes and he's filling 9 different parameters lines in sheet1. Sheet2 is hidden for him.
Normally to create a shared Mailbox i've 7 lines with different formulas filled with customer parameter and other
parameter which are always the same.
Now i just want to change the complete customer parameter tree in sheet2 with one click :)
1.Customer Parameter Line 1  - Create shared mailbox then switch to Parameter given in line 2
2.Customer Parameter Line 2 - Create shared mailbox  then switch to Parameter given in line 3
..........
I can do it with nine times having the complete formulas with different parameters in sheet2
but i want only one time the formulas with parameter in sheet2 and switching only the parameter
Regards
0
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 40287454
Like I said you can change the variable in Sheet!A1
exampleV1.xlsx
0
 
LVL 2

Author Closing Comment

by:Mandy_
ID: 40287455
wow! Thank you so much
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
A walk-through example of how to obtain and apply new DID phone numbers to your cloud PBX enabled users that are configured in Office 365. Whether you have 1, 10 or 100+ users in your tenant, it's quite easy to get them phone-enabled and making/rece…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question