Search results

Hi, Looking for a macro to find and replace in specific sheet (Data) and in specific column (A) for mutilple entries and replace in excel 2010. have around 1000 entries and list grows every month. Help will be really appreciated... example : Find :John Doe replace: John chang Find :karla jin...

@narunfca Arun We have another requirement added. To extract data based on year employee name and type of OFF day used ex. If year 2016 is selected and Emp1 from dropdown(b32) is chosen and any Off day selected from OFF days list(c32) - Must provide all dates taken in column D and notes...

Thanks nebu.. The first 4 queries worked and what part of your code makes changes to cells in column A in all sheets So what would be the formula to get back all data entered for each year? Really appreciate your help....

@Nebu Thanks for the code ..If you can provide minor adjustments 1. Don't want to hide any rows from the last sheet"dropdownlist" sheet. 2. Require to just unhide all rows from all sheets - Your code asks for "enter the row number" 3. Insert row - SAME( Don't want to insert row in last sheet...

Hi , Looking for macro for below queries 1. To hide rows in all named sheets ( jan ,feb,...dec,Total) with pop up user input message : Which row to hide? 2. To unhide all rows in all named sheets 3.To insert ROW in all named sheets with above formulas and formatting with pop up user input...

Awesome..Thank you Arun

Thanks Arun .. First part of query doesn't work : If Year Matches "Master" sheet Cell "A10" and Cell B10 with "Data" sheet cells "A1" OR "N1" should update in "Master" sheet cell I10 , J10 , K10 accordingly

Require additional data extract based on "Master" sheet Cell "A10" dropdown. If Year Matches "Master" sheet Cell "A10" with "Data" sheet cells "A1" OR "N1" should list in "Master" sheet cell I10 , J10 , K10 accordingly and also would be nice if "Master" sheet Column "B10" (All employee) gets...

Thank You so much Arun....Works perfectly!!!!!

It Works!!!1 Amazing.. Is it possible to add calender in "Master" sheet cell "C6"

Require assistance to extract info based on Master sheet column A10 (Year dropdown) and Column B10 ( Employee name dropdown) from "DATA" sheet starting from row27 output needed is the total in C10 ,D10 ,E10, F10 ,G10 , H10 from "DATA" sheet. Help will be appreciated ...

Made few changes to the code provided, Removed input box.However not sure how to give a break or wait after dialling primary number and wait for 10 sec before dialling the access code " 4444#" and then wait 10 sec again and dial the pin " *222" thru below code. Sub Numeric_RangeDataType() Dim...

Hello, Working on spreadsheet to dial out number using a macro, So far have been able to bring the dialer up and prompt to enter number. Need help to complete the code , see attached file Basically, Require to dial number out by pressing macro button from spreadsheet. Manual dialout method is...

Thanks @shrivallabha and @xlstime

Thanks xlstime ...It works. What was changed in the code , Coz if i copy code into exact another spreadsheet. It doesnt work.

Pasted above code in P15 by ctrl shift enter.. Doesnt Work .. Shows as 0.00

Hello, Need assistance in adding numbers with text in a row ,Total needs to be updated dynamically as numbers change in row. Have drop downs in cells to select V 1.0 or S 1.0,S 0.25, S 0.5 list ex : Row 4 : V 1.0 v 0.25 D 0.25 D 1.0 output reqd. Row 5 under P column 1.25 under S...

Sorry... All codes work just fine even with case sensitive items in col A,For some reason it was not doing on my first try for above codes. @jindon @Marc L @shrivallabha Thank you so much

Thanks for the replies..All above codes work but they are all case sensitive. If any item Colum A is typed as Grapes or grapes , Its creating new column.

Hi Everyone, I' ve been searching threads to convert multiple rows with same items to single column Header and get subsequent data related to items.Have huge data in multiple rows and column, Kindly provide a solution to convert multiple same data rows into columns as below. Have attached...

Agreed @Marc L ...Its a text in format (Sun 6/19/2016 12:09 AM) need conversion to format ddd mmm dd, yyyy - hh:mm AM/PM (Sun Jun 19, 2016 - 12:09 AM

System date mm/dd/yyyy

Hi , Need help in converting excel dates to proper format. If date such as Sun 6/19/2016 12:09 AM is copied onto cell needs to convert to format ddd mmm dd, yyyy - hh:mm AM/PM (Sun Jun 19, 2016 - 12:09 AM Tried changing cell format to above, used datevalue function - Gives an error #value...

Hello Guys !!! Any suggestion or help on below code to write data to last row. Any name selected after " ; " from dropdown menu in"2. Planning" Sheet must always write at the end of row in sheet "4. mobile" rivate Sub Worksheet_Activate() Dim r As Range, a, i As Long, e, x...

Hi, Came across this code to select multiple items from dropdown list.It does select multiple items seperated by ";" for second\third item. But when cell is double clicked to edit\add name for another item. It copies the old items and adds them again. ex. : selected Apples and oranges from...