Friday, May 24, 2013   
  Search   
 

Office 2010 - Launch Event

Register  Login  
Forums  
     Minimize  

MeraWindows Forums - Get your Computer Problems Fixed

This is a site run by the community - for the community. At the site, we share and contribute our computer learnings with each other. We discuss about Windows, Office, Mobile, Gaming and other computer related topics. At our forums you can post your queries and our very helpful community members will respond quickly to your queries. We organize lots of competitions from time to time and award prizes to the winners.
You will need to register at the site before posting in forums. It's absolutely free. After registering, you can get all the benefits available to our registered members, you can access our Downloads section, you can participate in contests, etc. You can post in forums in English as well as in Hindi, in fact we encourage you to use Hindi in your posts. If you have any problem with registration or login, please contact us.

     
  
HomeHomeMicrosoft Offic...Microsoft Offic...Microsoft ExcelMicrosoft Excelupdating sub sheets from Master data sheetsupdating sub sheets from Master data sheets
Previous
 
Next
New Post
3/28/2012 4:10 PM
 
I am facing one problem in linking sub sheets with Master sheet. I procure lot of items for many project like RIL, LFG,SEP etc. If I enter data in master data sheet and it should go directly to respective project sheets under specific month and year w.r.t. date entered in Master sheet.
 
 lokesh .xlsx
New Post
3/28/2012 10:16 PM
 
Manoj Singh wrote:
I am facing one problem in linking sub sheets with Master sheet. I procure lot of items for many project like RIL, LFG,SEP etc. If I enter data in master data sheet and it should go directly to respective project sheets under specific month and year w.r.t. date entered in Master sheet.

 Dear Ashish,
Waiting for your help.
Manoj

 
New Post
3/29/2012 2:16 PM
 
Dear Ashish,
I have customized my above mentioned problem. But still require some fine tuning, short possible method and to remove error in its formula as its showing Value Error in it.
Regards
Manoj Singh
 
 lokesh .xlsx
New Post
3/30/2012 4:51 AM
 
Hi,

Please refer to my formula in cell D6 of the LFG sheet.  It is a shorter formula and is non-array.

Let me know how it works for you.

For Microsoft Excel trainings in India, please visit http://www.ashishmathur.com/corporate-interventions/

Regards,

Ashish Mathur - View Ashish Mathur's profile on LinkedIn
Microsoft Excel MVP
Website
Blog
 
 Formula.xlsx
New Post
3/30/2012 10:10 AM
 
Dear Ashish,
when data in column C of Master data is repeated many times it doesn't work. Also when cell D6 of sheet LFG looks for blank B & C column in Masterdata, it returns value error.$B$7:$B$1000 &  $C$7:$C$1000
Please check the same.

Please try to remove error #value! in my sheet.

Regards
Manoj Singh
9958880220
 
 Lokesh12.xlsx
New Post
3/31/2012 4:23 AM
 
Hi,

You may refer to my solution in range D6:O7 of the sheet named LFG.

Let me know how this solution works.

For Microsoft Excel trainings in India, please visit http://www.ashishmathur.com/corporate-interventions/

Regards,

Ashish Mathur - View Ashish Mathur's profile on LinkedIn
Microsoft Excel MVP
Website
Blog
 
 Lokesh12.xlsx
New Post
3/31/2012 6:20 PM
 
Dear Ashish,
It doesn't display value for row 12 in Masterdata sheet to LFG sheet.
Can't you please ammend my formula in sheet posted previousy showing#value! error.

Regards,
Manoj Singh
 
New Post
4/1/2012 5:14 AM
 
Hi,

You may refer to my revised formula in the LFG sheet.

Let me know how it works for you.

For Microsoft Excel trainings in India, please visit http://www.ashishmathur.com/corporate-interventions/

Regards,

Ashish Mathur - View Ashish Mathur's profile on LinkedIn
Microsoft Excel MVP
Website
Blog
 
 Lokesh12.xlsx
New Post
4/3/2012 9:50 AM
 
Dear Ashish,
Thanx for solution. Now it works for me. But it make calculation too slow. Also my PC becomes too slow.I have i-5 processor with 4 GB RAM. Can you suggest some optimistic solution.
Regards
Manoj Singh
 
New Post
4/3/2012 10:22 AM
 
Hi,

You are welcome..  We can alternatively try to design a macro for solving this problem.  Would you be interested in getting a macro based solution.

For Microsoft Excel trainings in India, please visit http://www.ashishmathur.com/corporate-interventions/

Regards,

Ashish Mathur - View Ashish Mathur's profile on LinkedIn
Microsoft Excel MVP
Website
Blog
 
New Post
4/3/2012 11:33 AM
 
Dear Ashish,
Yes,please give macro solution for the same. I will be very thankful to you.
Regards
Manoj Singh
 
New Post
4/4/2012 7:35 PM
 
Hi,

You may refer to my solution at the following link - http://www.ashishmathur.com/programma...

Please comment on my site itself.

For Microsoft Excel trainings in India, please visit http://www.ashishmathur.com/corporate-interventions/

Regards,

Ashish Mathur - View Ashish Mathur's profile on LinkedIn
Microsoft Excel MVP
Website
Blog
 
Previous
 
Next
HomeHomeMicrosoft Offic...Microsoft Offic...Microsoft ExcelMicrosoft Excelupdating sub sheets from Master data sheetsupdating sub sheets from Master data sheets


   User Log In Minimize  


Register
Forgot Password ?

     
  
   Follow Us Minimize  
     
  
     Minimize