You are here:
- Home
- Computing/Technology
- Business Software
- Business Software
Business Software/Questions Answered by Expert Shahid
| Subject | Date Asked |
| How to merge sheets data in one sheet in excel? | 4/11/2012 |
| Q: Can you please help me out that how can I merge data of all sheets which is available in workbook in ... A: Try this... If rng <> Nothing Then If Left(rng.Value, 1) <> "0" Then trg.Cells(65536, ... | |
| How to merge sheets data in one sheet in excel? | 4/11/2012 |
| Q: Can you please help me out that how can I merge data of all sheets which is available in workbook in ... A: The actual data gets written in this line... 'Put data into the Master worksheet trg.Cells(65536, ... | |
| How can I reduce the file size? | 3/28/2012 |
| Q: Is there any way to reduce the size of the Workbook? Its around 1.36 MB in size and it takes time to ... A: Unfortunately, the Macro-Enabled part of the Workbook increases its file size. In addition, if you ... | |
| How can we count particular value in all sheets? | 3/27/2012 |
| Q: How can i count the particular values in all sheets? If conditions will be meet then only it counts ... A: You can't count across all worksheets since a 3D formula such as "=SUM(Sheet1:Sheet10!A1)" does not ... | |
| How to merge sheets data in one sheet in excel? | 3/26/2012 |
| Q: Can you please help me out that how can I merge data of all sheets which is available in workbook in ... A: Try these tutorial that can help you with merging. Note there are both VBA and Non-VBA (Google Data ... | |
| If user select the check box in the excel, then the particular value should be shown in the particular cell, if all condition have been met. | 3/23/2012 |
| Q: Now, I have new scenario for you. I think in this scenario VBA will be use. Or Please tell me what ... A: If I understand the code right, it will create the check boxes for you. Do the steps below... 1) ... | |
| If user select the check box in the excel, then the particular value should be shown in the particular cell, if all condition have been met. | 3/23/2012 |
| Q: Now, I have new scenario for you. I think in this scenario VBA will be use. Or Please tell me what ... A: Unfortunately, I don't know how to mass insert cell linked checkboxes. After googling for a while, I ... | |
| If user select the check box in the excel, then the particular value should be shown in the particular cell, if all condition have been met. | 3/22/2012 |
| Q: Now, I have new scenario for you. I think in this scenario VBA will be use. Or Please tell me what ... A: VBA is not required. Follow the steps below... 1) Right click and do a "Format Control" on each of ... | |
| ased on another sheet values, the values should be shown in another sheet. | 3/21/2012 |
| Q: Great job...!!! Shahid can you please add one more condition in that- if Sheet2 Cell H2 is "Pst" ... A: Please see if this works for you... ... | |
| Based on another sheet values, the values should be shown in another sheet. | 3/20/2012 |
| Q: I am back with my query with the image file.Also, I mentioned all the condition which should be meet ... A: In simple words, if I understand you right, you only want to check for Completed or Pending only if ... | |
| Facing problem while using formula. | 3/16/2012 |
| Q: Shahid, First I Congrats you as I can see your place in the list of expert is now on 2nd place. ... A: I tested the below formula in Excel and it worked for me. Do let me know how it works for you... ... | |
| Facing problem while using formula. | 3/16/2012 |
| Q: Shahid, First I Congrats you as I can see your place in the list of expert is now on 2nd place. ... A: I had originally anticipated something like thisand hence used offset function in the original ... | |
| How can we apply countif formula with multiple criteria in multiple sheets in excel based if particular condition has been met? | 3/15/2012 |
| Q: Once again I need your assistance regarding one of the formula. Now, I have scenario that how can ... A: I re-read your question.Correct me if i am wrong, but if i understand you right, if Cell A1of ... | |
| With the help of formula how can we get the particular values, if criteria have been met. | 3/13/2012 |
| Q: Shahid, Actually earlier I had given you an example. Now, when I implement in my sheet which I am ... A: Here is an updated formula... =IF(OR(COUNTBLANK(Sheet2!K2:K200)>0, ISERROR(MATCH("Pending", ... | |
| With the help of formula how can we get the particular values, if criteria have been met. | 3/12/2012 |
| Q: Previously asked question is not resolved yet. Kindly, give me some coding or give your valuable ... A: The formula has not been modified right. Firstly, I am guessing that your data lies in range ... | |
| With the help of formula how can we get the particular values, if criteria have been met. | 3/10/2012 |
| Q: Previously asked question is not resolved yet. Kindly, give me some coding or give your valuable ... A: I actually wanted you to post both the questions in seperate threads, anyway my answer below... For ... | |
| With the help of formula how can we get the particular values, if criteria have been met. | 3/9/2012 |
| Q: Previously asked question is not resolved yet. Kindly, give me some coding or give your valuable ... A: What problem are you facing with the first question? Please post a follow up with your current code. ... | |
| How to filter the values with help of combo box and populate the other controls? | 3/7/2012 |
| Q: Follow Up.......Below is your previous reply Hi Shoaib, If I am not mistaken, Excel does get locked ... A: Replace... .Range("A1:J1").AutoFilter Field:=2, Criteria1:=cmboconame, Operator:=xlAnd, ... | |
| How to save the excel data through the User form? | 3/6/2012 |
| Q: Follow Up... Simply change this line as required... emptyRow = ... A: If I am not mistaken, Excel does get locked up when a form is run, and if you can't switch ... | |
| How to save the excel data through the User form? | 3/6/2012 |
| Q: Follow Up... Simply change this line as required... emptyRow = ... A: Now you see why I chose Scroll Bars over buttons, less complication. Anyway, to answer your question ... | |
| How to save the excel data through the User form? | 3/5/2012 |
| Q: Follow Up... Simply change this line as required... emptyRow = ... A: I just reviewed your original question and the follow up, and I am sorry i didn't understand your ... | |
| technology | 8/13/2011 |
| Q: What is the Best Windows VPS server? A: I am sorry this is out of my scope. I know ZNet as a VPS Server, but it may not necessarily be the ... | |
| C# Language can used for erp? | 7/7/2011 |
| Q: Respected Sir, I have to develop a software based on ERP ,Is C sharp(Microsoft technologies ... A: then you can simply use a software development tool such as DotNet or Java. ERPs are usually bought ... | |
| Mobile Ad Serving Technology needed? | 7/6/2011 |
| Q: could you possibly lead me to a source that will help me obtain a mobile ad serving platform. How do ... A: Do you want to allow interested customers to advertise on your own apps, or set up a business such ... | |
| C# Language can used for erp? | 7/6/2011 |
| Q: Respected Sir, I have to develop a software based on ERP ,Is C sharp(Microsoft technologies ... A: Which ERP Platform are you working on? All ERP Platforms (SAP/MS Dynamics/ORACLE/etc) have their own ... | |
| Mobile Ad Serving Technology needed? | 7/5/2011 |
| Q: could you possibly lead me to a source that will help me obtain a mobile ad serving platform. How do ... A: .. whoa, your question is out of my expertise, but I will try to give you some direction. Companies ... | |
| Need BPO QC software | 6/9/2011 |
| Q: I need an QC software which does the following work. * Analysing the image and reading total ... A: Net Code, Employee Call Register, etc. Your bullets have me think about MS Word first, but I guess ... | |
| Online CRM Solutions | 1/17/2011 |
| Q: Greetings. I have a client(5 users) looking for a simple CRM application that will integrate with ... A: Give your basic and specific requirements, on of the tools that comes to mind at once is Zoho. ... | |
| Instructor's Payroll (Flexible) | 11/30/2010 |
| Q: My name is Issa Mahshi - I am the managing partner of Berlitz Language Center in Jordan. We ... A: You should really have a good idea of your budget to begin with since this greatly influences futher ... | |
| Instructor's Payroll (Flexible) | 11/30/2010 |
| Q: My name is Issa Mahshi - I am the managing partner of Berlitz Language Center in Jordan. We ... A: Assalamu Alaikum Issa. First, thanks for performing the good step of detailing your requirements. ... | |
| Microsoft Office 2010 with Vista X86 flatform | 11/6/2010 |
| Q: I have a windows Vista computer that used to have Microsoft Office 2003. Now I am installing ... A: you may not want to do this on your own and may want to get in person help. Nevertheless, I will try ... | |
| Title service company software? | 10/9/2010 |
| Q: Can you tell me what type of software I could use for my Title Service company (Car registrations, ... A: Sorry I couldn't be of better use to you as this area is not within my domain knowledge. I would ... | |
| Title service company software? | 10/8/2010 |
| Q: Can you tell me what type of software I could use for my Title Service company (Car registrations, ... A: I took a look at your state's MVD website and found that there is currently no recognized software ... | |
| Title service company software? | 10/8/2010 |
| Q: Can you tell me what type of software I could use for my Title Service company (Car registrations, ... A: This is out of my expertise, but will try to help you. I may need some information first. What state ... | |
Shahid
Top Expert on this page
Expertise
I can answer questions regarding good software fit for your organization and needs, tips on how to overcome change resistance, design tips of IT solutions for your business needs, and more. Hire me to work on your project at vWorker.com
Experience
I have been working in various roles for over ten years, part of those in the Business side and the other in Information Systems designing IT solutions for firms and planning and executing implementation strategies.
Education/Credentials
M.Com - Mumbai University, Mumbai, India
MS(IT) MBA(IS) Dual Degree - Bentley University, Waltham, MA, USA
©2012 About.com, a part of The New York Times Company. All rights reserved.