Question:I have - Table 1 and Table 2How can I bring salary information in table 2 from table 1 for corresponding dept and jobcode?ThanksBob LeeOur take on this excel problemYou can join Department and Job Code in both table 1 as well as 2 using...
Topics: Clever Excel formulas

{"title":"Reader\u2019s Questions - Performing two-way look up","post_url":"http:\/\/www.handyexceltips.com\/2009\/03\/16\/readers-questions-performing-two-way-look-up\/","feed_url":"http:\/\/www.handyexceltips.com\/feed\/","author":null,"date":"2009-03-16 13:08:43","summary":"Question:I have - Table 1 and Table 2How can I bring salary information in table 2 from table 1 for corresponding dept and jobcode?ThanksBob LeeOur take on this excel problemYou can join Department and Job Code in both table 1 as well as 2 using..."}

If you copy and paste values from one column to another, when the filter is on and the range is discontinuous,  then it won’t work and will paste the data into non-visible cells as well.Share ThisSimilar Posts:Concatenate functionDragging a...
Topics: Clever Excel formulas

{"title":"How to copy and paste values in filtered data?","post_url":"http:\/\/www.handyexceltips.com\/2008\/11\/11\/how-to-copy-and-paste-values-in-filtered-data\/","feed_url":"http:\/\/www.handyexceltips.com\/feed\/","author":null,"date":"2008-11-11 05:57:11","summary":"If you copy and paste values from one column to another, when the filter is on and the range is discontinuous, \u00a0then it won’t work and will paste the data into non-visible cells as well.Share ThisSimilar Posts:Concatenate functionDragging a..."}

If you want to create a new workbook in some folder and you are already there, then instead of clicking on excel icon and then making your way to the folder by clicking down through the folders until you reach the desired location where you want to save..
Topics: General

{"title":"Save a new worksheet directly in the desired folder","post_url":"http:\/\/www.handyexceltips.com\/2008\/10\/21\/save-a-new-worksheet-directly-in-the-desired-folder\/","feed_url":"http:\/\/www.handyexceltips.com\/feed\/","author":null,"date":"2008-10-20 21:17:51","summary":"If you want to create a new workbook in some folder and you are already there, then instead of clicking on excel icon and then making your way to the folder by clicking down through the folders until you reach the desired location where you want to save.."}

This article gives you an example of where we may need to keep our formulas intact.Share ThisSimilar Posts:Is there any de-concatenate command??Indirect FunctionPerforming Two-Criteria LookupFinding external linksConcatenate function
Topics: Clever Excel formulas

{"title":"Freezing Formulas","post_url":"http:\/\/www.handyexceltips.com\/2008\/09\/05\/freezing-formulas\/","feed_url":"http:\/\/www.handyexceltips.com\/feed\/","author":null,"date":"2008-09-05 02:27:11","summary":"This article gives you an example of where we may need to keep our formulas intact.Share ThisSimilar Posts:Is there any de-concatenate command??Indirect FunctionPerforming Two-Criteria LookupFinding external linksConcatenate function"}

This article shows how to locate cells in active workbook which contain links to external workbooks.Share ThisSimilar Posts:Accessing other worksheets in a workbook faster10 ways to open excel fasterSelecting Multiple WorksheetsPerforming Two-Criteria...
Topics: Excel Functions, Macros

{"title":"Finding external links","post_url":"http:\/\/www.handyexceltips.com\/2008\/07\/15\/finding-external-links\/","feed_url":"http:\/\/www.handyexceltips.com\/feed\/","author":null,"date":"2008-07-15 05:18:13","summary":"This article shows how to locate cells in active workbook which contain links to external workbooks.Share ThisSimilar Posts:Accessing other worksheets in a workbook faster10 ways to open excel fasterSelecting Multiple WorksheetsPerforming Two-Criteria..."}