Search results

Dear Jack.. The below might resolve the issue http://blog.contextures.com/archives/2010/08/18/unwanted-files-open-automatically-when-excel-starts/

Dear All I came up with strange question that how to round up 9 digits ? The question may be strange. Lets elaborate more.. In a cell A1, if the cell value is between the 1-9 then it should round up by 9 digits otherwise it should round down. For example 281 should be displayed as 290 9...

In 2007 or above, Press Developer Tab (If not appears, go to file->options->customise ribbon-> right hand side pane, tick Developer tab) and press Macros Tab->a Macro Popup window will come->select your macro name -> click options -> then you can assign short cut key.. I hope this information...

Dear Rajesh.. You can achieve this by using FileSystemObject Library. Before proceed further, please confirm that, 1. Do you want a pop window to select a folder or you want to hard coded in your code. 2. Is structure of the workbooks are same 3. Do you want to copy all the data, from...

To understand and debugging the code.. can you please upload your file. It will help to resolve the problem fastly

Dear Jb, You can call your macro by putting your code in worksheet object. In VBE, just double click on your desired worksheet in left side panel and then right side a combo box contain General, change it to worksheet. Just have a try and revert Private Sub Worksheet_SelectionChange(ByVal...

Dear Jack.. The provided link, requires login information. So please upload the file directly in this forum, no need for third party data storage sites.

Dear Jack.. The above formula =COUNTIF(F2:F51,AB3)+COUNTIF(Q2:Q51,AB3), lets break it for better understanding First of all, you should aware the syntax of COUNTIF. The syntax is COUNTIF(Criteria Range, Criteria). Excel will count your criteria from the Given Criteria Range and returns the...

Dear Kumar... Sorry, i was messed up with my Office Work... In your attachment ,i could not able to find that, how can i determine that i have completed the 1st row, 2nd row.... like so on. Which condition will say that, the row has completed? Can i assume that, if all the cells in a row has...

Can you please upload your sample file...

You can achieve this by Conditional Formatting, before that i need some info you mentioned 160 Rows, but how many columns? Is there fixed range or dynamic range? Can we use helper column? Which type of data you have? Assume that your data is in A1:E10 select your range-> conditional...

As per your information.. the change may happen in Columns (insert new columns, delete columns or shuffle the location of the columns) not in Rows. So is there any starting point ? like as per your attached file the starting position is B2. Next question is, Is your data will be in continuous...

Your question not so much clear... but one thing i understood that, you want to set range dynamically i.e from B1: Px.... So i will prefer to have a look at "How to find last used cell in a range" or something like... Then you can use that last used cell in your range. Assume that your data is...

If i understand correctly... just drag actions tab in values field. It will give the count of all

You can also try =DATE(2014,6,30)+(52*7) to get your desired output in a cell

I think, calculation mode set to manual, please check calculation mode by clicking formulas tab and then calculation options, then automatic (if not ticked)

Thank you much @ThrottleWorks & @NARAYANK991 @NARAYANK991 I already tried these websites. @ThrottleWorks http://www.pesebooks.com/professional-outlook-2007-programming-paperback-PDF-804233/. It asks for Credicard verification. Can it be possible to you to download the file without paying...

Dear All, Sorry if i post wrongly. I want to learn programming in Outlook 2007 & above. I googled everything, but lastly I found a book namely "Professional Outlook 2007 Programming" by Ken Slovak. I read this book (not all pages, some the pages) through google books. I tried a lot to get the...

I think you can turn off this feature in excel options. In excel 2010, File->Options->Formulas, then there you can see "working with formulas" in that R1C1 reference style. Just remove click on that. May be this is the right way to turn off the R1C1 style. Please try and share

Dear bluetaurean, I would suggest this forum for to improve or test your excel skills. In this forum, so many people around the globe post their real time problems which they are facing in their life and so many excel experts are here to resolve their problems through their excel experience. So...

Dear Jenn1981 I think, you can achieve it by VBscript. Please put all your code in a notepad and save it as .vbs extension. To run automatically, you can put vbs in Task scheduler.

Will this work for you? =LEFT(A1,FIND("@",A1)-1) Here A1 is the email address

Congrats ......:):):)

Dear Mukund.. In Pivot table, just move your Party Name field to Report filter Field. Here you can see all the part names, If you want to see the details of a particular party, then select party name in the report field, it will show the details. You can google it for difference between...

Dear Mukund.. As i already explained you that, your format is not in standard. So please put your format in standard, It wil resolve