• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Import data from master sheet into other sheets within workbook without using VBA

W

westend9876

Member
I have a master sheet in my workbook called LEVELS which contains pricing data for currencies. There are three columns of data for each currency pair. Each currency pair also has its own named worksheet within the workbook like EURUSD, EURJPY, USDCAD.

I need to import the data for each currency pair from the LEVELS sheet into each of the respective named currency sheets.

I attached a simple workbook as an example of what I need. Thanks.
 

Attachments


Hi westend9876,

without any code, you have to enter a formula in the first cell, Excel beginner basics !

For example in cell B1 of EURUSD tab : enter = sign and thus click on LEVELS tab,
select cell B3 and valid by ENTER key.
Select cell B3 and by its lower right coin (sign +), copy to the right.
Now copy the same way both down … Voilà !

You succeed for the fisrt tab, do the same for others …
​
 
Deepak said:
Nothing!!!:)
Jusy copy paste in desired sheet.
Click to expand...
I tried that. I copied the formulas in USDCAD to EURUSD. But when go to sheet EURUSD and press F9 to calculate the EURUSD sheet (because I turned off auto calculate) the values from sheet USDCAD are changed to those in EURUSD. The same thing happens when I go back to USDCAD sheet and press F9. The values are corrected in USDCAD sheet but changed in EURUSD to those in USDCAD.
 
NARAYANK991 said:
Hi Deepak ,

Instead of using RIGHT(CELL("filename"),6) , use RIGHT(CELL("filename",$A$1),6).

See the file.

Narayan
Click to expand...
NARAYANK991 said:
Hi Deepak ,

Hi. There is one problem with these formulas from both Deepak and Narayan that occurs when the column is two letters like AA, AB, AC, AD:

=INDIRECT("LEVELS!"&CHAR(MATCH(RIGHT(CELL("filename",$A$1),6),LEVELS!$B$1:$G$1,0)+65)&ROW()+1)
=INDIRECT("LEVELS!"&CHAR(MATCH($J$1,LEVELS!$B$1:$G$1,0)+65)&ROW()+1)

What do you do then?
Click to expand...
 
Deepak said:
Check with Attached!
Click to expand...

Hi. There is one problem with these formulas that occurs when the column is two letters like AA, AB, AC, AD:

=INDIRECT("LEVELS!"&CHAR(MATCH(RIGHT(CELL("filename",$A$1),6),LEVELS!$B$1:$G$1,0)+65)&ROW()+1)
=INDIRECT("LEVELS!"&CHAR(MATCH($J$1,LEVELS!$B$1:$G$1,0)+65)&ROW()+1)

What do you do then?
 
Try this..


B2=INDIRECT("LEVELS!"&ADDRESS(ROW()+1,MATCH(RIGHT(CELL("filename"),6),LEVELS!$B$1:$G$1,0)+1,4,1))

C2=INDIRECT("LEVELS!"&ADDRESS(ROW()+1,MATCH(RIGHT(CELL("filename"),6),LEVELS!$B$1:$G$1,0)+2,4,1))
 
Deepak said:
Try this..


B2=INDIRECT("LEVELS!"&ADDRESS(ROW()+1,MATCH(RIGHT(CELL("filename"),6),LEVELS!$B$1:$G$1,0)+1,4,1))

C2=INDIRECT("LEVELS!"&ADDRESS(ROW()+1,MATCH(RIGHT(CELL("filename"),6),LEVELS!$B$1:$G$1,0)+2,4,1))
Click to expand...
Hi Deepak. These two formulas do not work. Thanks.
 
You must log in or register to reply here.
Back
Top