Search results

Hi Everyone! I prepared a userform through excel and stuck to action an option. I have an excelsheet, "List" with details from A1 to B10(row data keeps extends) and I have created a userform and linked the data source as per the list and now the list displays with all the information in 3...

Hi there, I have written a macro and assigned to a button on the excel. Once I clik on the button, the current excelworkbook goes as an email. Now, the challenge is with the size of the file. As its a huge file, is there any way that once I click on the button it automatically zip the file...

Hi there, I have created a form on a excel spreadsheet and need your assistance in finishing it. I have inserted a checkbox with caption as Financial ledger balances for corporate. Now I want the ledger balance be displayed in blue and underline and the rest be in black in color. I tried...

Hi All, Is there any way I can remove all hyperlinks in my excel spreadsheet at once!? Regards, KK

Hi there, Good Morning! I have an excel form where we usually fill the form and save as the file in our local share drive with a name as per B5 cell. Is there any way that once user enters a name on B5 cells the form should automatically save as onto the sharedrive with B5 cell data as the...

Hi there, I know it is silly, but I actually stuck in getting the solution. I have a share point dowloaded data in A to H columns. My G and H columns shows me the dates like below: G Column: 08/21/2012 08:20:25 AM 08/20/2012 02:20:10 PM H Column 08/21/2012 08/20/2012 Now, I want G...

Hi there, Happy to post another query here. This is also the place where I am actually improving my excel skills. Thanks to that. Query: I have some multiple macro embedded excel files saved in the share drive. As I am currently working on some project, hence I keep changing the macro code...

Hi there, We have an excel file(not shared) saved in a common shared drive where users go and update the data quite often. But, this morning we have faced a magical problem in opening that excel file. It says file is already opened by ....(user id) and asked to whether to open the file as a...

Hi Team, Can you please help me to restrict entering duplicate values in A and C column. For example, if I enter 1(A1 CEll) and 1 again in (A2) then the A2 cell should not accept and should prompt and error messages says - "Duplicate value". Same way for C column also. One more, user can...

Hi there, Need one more assistance on copy & pasting data. For example, I copy data from spreadsheet1 and wanna paste the data in spread sheet. The challenge is i filter some columns in the spreadsheet2 for some validations and then I wanna paste the copied data onto the filtered range...

Hi there, I have inserted some comments in a spreadsheet in A10, B11, B15, C25 and so on.... Now, i need to extract all comments in another spreadsheet or in the same spreadsheet at one shot. If possible let me know a technique to extract(something like - copy & paste) all comments with or...