Recent content by shankar_iyer83

Thanks G! I managed to have a look(will work on it later over the weekend) Have send you message in your inbox!

Thanks! I shall wait for that I first tried to use Vlookup then Match+ Index etc.but somehow was not able to arrive at consistent result

Thanks G! How did you start to create code etc so that I can try it on own when I have time I am not a VBA/Macro guy so if it involves that I will not poke my nose further! Tha

Thanks G! I seem to get slowly Now need more of your inputs here! My actual working official file where I need to use has data for whole month working days (say for decemeber 1 to December 31st barring saturday/sundays). If I use your file..it doesnt shows full month data. I may have to edit...

Hi G, Thanks for reply. I started to do as you told. I opened your file "ShankarPQTranspose".xlsx but I get this error? Also, sorry if it sounds silly, can you guide me more on what exactly I have to do with this file and how to make changes using this file to my earlier posted files...

I can enter date manually in first column and drag( thats not a problem) and yes data in those five columns (actually there are more columns) should copy from original file corrosponding to that date Hope I am clear

Hi G, Yes, I am using excel 2016. Sorry I did not understood how to do it and make changes. I could find "New query" tab under "data" but after that I could not understand Could you please explain it in detail. I do not know much coding/VBA but will try to apply here with whatever I know

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...

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...

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...

Thnaks, Can you please explain logic...may be breaking down bit so that I can understand in much better way..

@Rahul, Thanks, The issue here I cant modify two files (add rows/delete rows), so if I do not use column E and simply use formule,will it work? Secondly, I need to refer to other file if I reference to that , is it fine?

Anyone/Narayan, Would be grateful if you could type formulae for me to get output. I could not understand it

Hi, I have two excel files. and when I use Vlookup to copy values from one file (sample original file) to another (similar file) , its not working for duplicates. After checking, I see there are lots of duplicates and its picking first value. How do I put it to get all values ? I tried to use...

any one , please reply