Issues in Copy data from one file to another

[shankar_iyer83]

Hi,

I need to copy data from other file for the days of month. However, when I use hyperlink and drag it down/left/right .it does not pick correct values.

How to do this linking for all days? Attaching file with sample data and kind of output I want

I need to copy data from "Original file.xlsx" (the format is same as I mentioned in file )

and paste it in "Avg Bank balance sample.xlsx" file (I have to manually copy and paste it as of now)



Please help

 

[Thangavel]

You can try with Index+Match formula to get your desired result.

 

[S. Das]

Shanker, you have already posted this query in your previous thread
https://chandoo.org/forum/threads/copying-data-from-one-excel-file-to-another.36887/

And this is a duplicate post. If you have any further query then you should continue that conversation with our experts in the above link so that future users can see the full conversation.

 

[Hui]

Shanker

This is a duplicate of your post at: https://chandoo.org/forum/threads/copying-data-from-one-excel-file-to-another.36887/
There are 2 solutions posted there which you haven't responded to?

Please take the time to:
1. Read the responses to the original post and respond accordingly
2. Read the site rules at: https://chandoo.org/forum/link-forums/new-users-please-read.17/