Sunny Madan
New Member
- Joined
- Apr 21, 2014
- Messages
- 1
Hi all,
I am new to Excel world.
I know basic functionality and many of the functions of EXCEL.
This is what i am looking for.
a. In 'Sheet 2' - In cell 'A1' i have a concept 'Assets', In cell 'B1' i have formula how to my concept is calculated '= Current Assets with 2010 of India + Non Current Assets with 2010 of India'
b. Values for 'Current Assets' is stored in my 'Sheet 1' in this format 'Current Assets_India::2010'
c. what i am doing is writing formula in 'B1' =(VLOOKUP("Current Assets_India::2010",Sheet1!A1:B14,2,0)+(VLOOKUP("Non Current Assets_India::2010",Sheet1!A1:B14,2,0)
d. Can anyone help me with a macro so that these formulas are automatically created.
Thanks in Advance.
I am new to Excel world.
I know basic functionality and many of the functions of EXCEL.
This is what i am looking for.
a. In 'Sheet 2' - In cell 'A1' i have a concept 'Assets', In cell 'B1' i have formula how to my concept is calculated '= Current Assets with 2010 of India + Non Current Assets with 2010 of India'
b. Values for 'Current Assets' is stored in my 'Sheet 1' in this format 'Current Assets_India::2010'
c. what i am doing is writing formula in 'B1' =(VLOOKUP("Current Assets_India::2010",Sheet1!A1:B14,2,0)+(VLOOKUP("Non Current Assets_India::2010",Sheet1!A1:B14,2,0)
d. Can anyone help me with a macro so that these formulas are automatically created.
Thanks in Advance.
