Search results

Hi, In the attached spreadsheet I'm trying to fill in the blank cells for Columns A thru F automatically using Special > blank cells. However, it does for the entire column which is not what I want. I would like to fill in only when there is a value like shown in the desired output. Column A -...

Hi Andrews, Welcome to Chandoo.org. You could use the indirect function to list values based on the criterion as required. In the attached sheet refer to sheet 4 to use drop-down's. The base information of the drop-down values could be found in Sheet 3. You could find more detailed...

Hi, I tried to use the auto scheduler as an option to run macro but wasn't really successfull in my attempts. could you please help? Thanks in advance. Kind regards, A!

Hi team, I have a list of 5 sheets and they work in a sequence. I have to run them everyday and it takes 2 - 3hours every day for every file and I'm looking for a solution with which can run like batch update all by itself update like the below: File 1: runs the macro at 16:00hrs, saves the...

am not surprised at all, one of the geeks in excel here in chandoo. you are a rockstar friend. congratulations :)

Hi Gaurav, You can use something like the below. Make sure you update the email id's and the subject accordingly. You could also find additional information here. http://www.rondebruin.nl/win/s1/outlook/mail.htm Sub Mail_Single_SendRequest() 'Working in 2000-2010 Dim wb1 As Workbook...

Hi Priya, Attached zip file includes the consolidater as required. The below is the step by step approach. 1. All the files have to be in one specific folder only thats when they would work else they will not. 2. The file 'Master.xlsm' has a get data button and this will extract the data of...

Hi Priya, Column E is formatted as 'Text' change it to formula and then hit f9 or click formulas ribbon to calculate sheet. This should work fine. Kind regards, Anand

Hi Luke & Deepak, I was able to fix this. There was a filter in one of the fields and thats why I kept viewing this error message. After I removed the filter, it worked fine. Thanks once again as always grateful. Kind regads, Anand

Hi Luke, There are no merged cells and none of the worksheets are protected but for some reason I keep getting error messages. I spent my day exploring various options but didn't help me at all. Not sure what I'm doing in correctly. Kind regards, Anand

Hi team, I'm very sure that I'm doing something wrong in the below code because of which everytime it shows up debugging error stating 'copy method of range class failed'. Any suggestions / advise? I'm trying to copy the range E4:N4 to E6:N60000 with formulas in the same worksheet. I tried...

Hi Mudassar, Try the below. The ribbon, select the tab 'Data' and click 'Edit Links'. more detailed information is in the below links http://office.microsoft.com/en-gb/excel-help/break-a-link-to-an-external-reference-HP010342210.aspx...

Hi Kaushik, I believe you were trying to retrieve data based on account code drop-down. Attached is the updated sheet. I was not sure how do you calculate total but I leave it to you. Hope this helps. Regards, Anand

you could also try format > custom> 00.00. should work I think.

Hi Atul, I think you are trying to show up values as 00.39 instead of 0.39, correct me if i'm wrong. Try the following link with instructions. http://www.extendoffice.com/documents/excel/664-excel-display-hide-zeros.html

Hi jagdev, It would be easier if you can share a sample workbook and point out where the formula is. Kind regards, Anand

Hi Michelle, Attached is a sample sheet for your requirement and I hope this solves your question. Having said the below, I have put together a different approach which avoids pivot table. 1. Create a template with data which can pull the user specific data using index and match. The user...

Hi, I have a large amount of data and I'm need to pick up data like in the attached sheet. I could use index match to pick up the related items but has its own limitation and I'm stuck with this puzzle now and i think i need a vba code to run the index match to pick up this view. Please help...

Hi Paul, If the formula is missing parenthesis this happens. could you verify if the formula is not missing parenthesis? you could also share the spreadsheet as an example after sanitizing it. Kind regards, A!

Hi Narayan, its a perfect gift for me this morning. works like sunshine. Thanks you... Kind regards, A!

thank you for explaining me this. im very sure that I will soon enroll myself for the VBA and advanced excel class in chandoo.org to be more proficient in the usage of excel many thanks narayan. Kind regards, A!

thank you for the detailed explanation narayan. this code that I use now generates the desired results but sometimes the last row range is taken beyond the filled in range. for example the values are filled only till row 38 but the formulas are updated for 73 rows which i dont want and this...

works perfect Narayan. you had stated in ur last post that don't use used range. can i keep using this as sometimes calculates for other ranges than specified. please advise. Kind regards, Anand

Attached is the file that im working on presently. the macro a. inserts the formula for me in my specified range b. inserts blank rows for me c. updates formula for me but it does only until one row above the filled range d. after this is sorted I have to repeat the same steps to include...

Hi Narayan, thank you for the link. I modified the code to the below. I'm able to navigate to the last filled cell range but not sure how to paste the formula after the last filled cell range. could you please advise. many thanks once again. Sub workingtest() i = 2 For Each c In...