Search results

Hi Manish, Add this code to the module . This closes only the Workbooks beginning with "Data". Sub CloseOpenDataWkbk() Dim wkbk As Workbook For Each wkbk In Workbooks If Left(wkbk.Name, 4) = "Data" Then wkbk.Close True End If Next wkbk End Sub [/CODE=vb]

H James, The steps I mentioned in the previous post very much does the same job as what you are trying to do. The chart you copied to all the worksheet will hold the source to the same data as the master worksheet. If the chart in the Master worksheet changes, then the slices on all the sheets...

@Narayan, Is it a good way to write a macro on user's workbook/s to update the validation list data whenever the data gets changed on the master workbook (on the network server)? user will have to click a button to get the latest data on their individual workbooks. This way we can make it work...

Hi Sudipto, If you are with Office 2003, do not worry. You can send it to any one on the email. If you are with Office 2007/2010 or higher, please make sure you save the file as .xlsm format (Excel Macro- Enabled Workbook) . You dont need to change anything on VBA. Wherever the file goes, it...

Hi James, You can copy the Pie-Chart on the Sheet #1 to all the other sheets (2 to 12). This will hold the reference to the same data source, so change in data will change the charts in all the sheets. To make the slices invisible except one slice on each sheet, follow the below steps. On...

Hi Hreyo25, Change your line of code with this. ActiveSheet.Range("$A$6:$T$15000").AutoFilter Field:=1, Criteria1:= _ "=Square*", Operator:=xlOr, Criteria2:="=Circle*"

Hi Sudipta, Wondering why they don't want you to use the Autofilter!!! Anyways, you can use VBA code to do the same task as the Autofilter does. But this is not as swift as the Autofilter does. Add the below code to your Sheet module. (Alt +F11 to open the VBA editor and paste it in...

Hi Sudipta, You can do this by locking the portion of your cells and protecting the sheet. I cannot upload the file and hence the steps to do it. 1) Apply Autofilter only to Column E (Div) 2) Select all the cells ( Ctrl + A), Right Click -> Format Cells -> Go to Protection tab and check...

Hi TG3, Record a macro for all the actions you described. Thats why the macros are for. Click of a button should do all your actions in seconds. Please let me know, if you need any help to create a macro .

Hi Bhushan, How is the data getting updated? Is that on a regular interval triggered by Excel event ? or using RTD formula? or any other method. There has to be some trigger or a interval to refresh the data.

Hi Deb, This video pretty much talks about your requirement. Hope this helps. Just that you need to show the Secondary Axis and define the minimum and Maximum units of it with the TotalPost values.

Hi Bhushan, Try the below code on the Sheet1 code module. The below code executes while any value gets changed on the sheet1 and checks if the 4th column of the value changed row has the text "Target Achieved". If so, it copies the entire row data to the sheet2. Note that the code counter...

Hi Oldchippy, We might have to tweak your formula a bit as this fails for the text like "GetGrandLookGetGrandLook".

Hi Sambashivamk, Sample sheet, as you mentioned is not attached. Attach it for us to help you.

Hi Krishna, Please try the below link which has a VBA code to protect the PDF with password. However it requires a PDFCreator reference to make it work easy. If this doesn't work, please post your code of PDF creation as I can give a try to check for the security options. Thanks...

Hi Villalobos, You can have the below code under all the worksheets Selection_change event . Even if any user enables the Headings, it will get hidden before they do any action on the worksheet. Then You can protect your VBA code with a password for someone to change it. There should be a...

Hi Portucal, Did you check the syntax of the formula? Ampersand(&) is missing and that could be areason not to make a proper hyperlink. Try this. =HYPERLINK("http://www.mywebsite.com?param=("&A2 &")")

Hi sgmpatnaik, 1) Did you check the Excel Disabled items ? File-> Options-> Addins-> Manage(Disabled Items) -> Go (In Excel 2010) . Check if any of the addins/files are disabled and sitting over there for any reason. 2) Delete the Excel.box file %appdata% \Microsoft\Forms\ folder. This...

This helped me to resolve some of my Excel issues and even couple of posts on Chandoo. Get.Cell() http://www.excelfox.com/forum/f13/excel-macro-functions-get-cell-75/ Get.Document() http://www.excelfox.com/forum/f13/excel-macro-functions-get-document-76/

Hold on Masters!!! I am a member with 100+ posts and have read all your comments twice before I dare to write up here. Yes... I agree with you all that google god grants almost everything you ask for and makes you wiser overtime, if you have a desire, passion and time to learn on. But, as a...

Hi Luke, Thanks for solving this. I was cracking my head from more than an hour about combining the named ranges from different sheets. Just simple and elegant answer. Thanks.

Hi , Is that with VBA or the Excel function your are trying with. Do you have any sample for this?

Hi sgmpatnaik, SaveAs the worksheet Normal as you are doing now (This should bring in the sheet along with formula & formats). Copy all cells and paste as values. Try the below. Sub SaveSheet() Dim New_file_name ' Written by Barrie Davidson New_file_name = Application.GetSaveAsFilename(...

Well.. Add to your vault. Its new, fresh and released today. http://chandoo.org/wp/2013/10/30/become-awesome-with-vlookup-book/

Hi Debraj, Is that the Windows theme causing this? Worth checking by changing the theme to something similar of Windows7 etc.,