Search results

@NARAYANK991 Apologies for late reply. Thank you .. It worked

Not sure how to edit my previous post , Reposting with more clarification Not getting desired result with conditional formatting , With below formula color changes if only cell is clicked. =NOW()-INT(NOW())>E1+TIME(0,1,0) =NOW()-INT(NOW())>E1-TIME(0,15,0) If anyone can provide vba with below...

Hi, Cell E1 date / time extracted from another sub routine in format (m/d/yyyy h:mm AM/PM). require help on date / time background cell color to change. Not getting desired result with conditional formatting, Kindly suggest. E1 - Default background color - green E1 time less than 15 minutes...

@Hui Have uploaded sample file and as shown in below images, data is written on header file if any new row is inserted. Any suggestion to reference above code to always write data below header file row 17 even if users add row above. Kindly have a look at my code in attached sample file...

Hello, Not much experience with writing macros and with help from some awesome forums and googling have put pieces together. Having issue running on my original file as data is huge. It takes atleast min to search a name and extract data. Need help from experts to run below code faster and if...

My code starts from row 60,If any row inserted above row 60. There's mismatch of data.

Hello, How to modify below query to always start from Row 60 (sheet4) even if new row inserted above row 60? Thanks for helping out... Dim i As Long Dim j As Long Sheet4LastRow = Worksheets("Sheet4").Range("D" & Rows.Count).End(xlUp).Row sheet5LastRow = Worksheets("Sheet5").Range("A" &...

Hello, Require assistance with below query to paste information to master sheet(Contact) based on cell clicked and value filled Help is much appreciated... Have 3 macros running : 1. First code runs to split fullname from (2. Planning) sheet column D and insert in (4.mobile) sheet (Column D...

Not very familiar with with advanced filter and how will worksheet_change event solve issue 2 and 3. In above attached file, extracting data and copying missing data back to original file.. Thanks for suggestions...

Marc, That's a sample sheet attached and have other conditional formulas running in Column B of mobile and Column G of contacts. 1.Was able to get first issue solved by running this macro below to auto-populate data in (mobile) from master (Contact) sheet. 2.Issue am having is :extracted info...

hi, Was wondering if this could be achieved thru vba as have tried using formulas and vlookup thru matching criteria and it takes forever searching huge database(Have around 5000 rows) Have 3 conditions to meet: 1. Need to match and copy column A and B from sheet (Contacts) and auto populate...

@jindon Can the code me modified/added to select row and copy all formulas in that row and insert down Rows("18:18").Select ' select row number 18 Selection.Copy ' copy it Selection.Insert Shift:=xlDown ' insert a copy of it Private Sub Worksheet_Activate() Dim r As Range, a, i...

Is there anyway thru macro that any new item added,must always add to end of list.

Uploaded test file..Not sure how to use data,text columns..staff has to enter dates as email comes in daily

Date is copied from another application and pasted into excel.Column K an L has been formatted to "ddd mmm dd, yyyy - hh:mm AM/PM" and format painter doesn't work. When date "Fri 4/29/2016 3:16 PM" is copied , It doesn't change to "Fri Apr 29, 2016 - 03:16 PM" Require a macro to change to...

@jindon Any suggestions on this request??

Hi, Need help with setting up custom date format "ddd mmm dd, yyyy - hh:mm AM/PM" in specific columns K and L. If "Fri 4/29/2016 3:16 PM" copied onto cell ,Should change to "Fri Apr 29, 2016 - 03:16 PM" format.

Hello, Require - Macro to extract data based on match first and last name 4. mobile(Column D and Column E) row starting from 18 Match Column A and Column B (8.contacts sheet) and extract\copy data based on match to 4. Mobile sheet row starting from 18 Fill Column A (4. mobile) extracting...

Hello Ninja's Have deadline to meet , code was provided by Jindon.Need help to do few corrections 1.If any name is selected by dropdown menu in "2. planning sheet column C" must always write to end of list in "4. Mobile D and E" In attached sheet example, If another name is selected from...

Private Sub Worksheet_Activate() Dim r As Range, a, i As Long, e, x Application.EnableEvents = False With Sheets("2. Planning") If .Range("c" & Rows.Count).End(xlUp).Row > 12 Then a = .Range("c12", .Range("c" & Rows.Count).End(xlUp)).Resize(, 2).Value End...

Hi, Searching for a macro to pop message "Send email" based on cell (Sheet2. E1) (date and time) every 4 hours. excel 2010 ver Help will be really appreciated.

@Luke M Thank you Luke...It works.

@Luke Added line code provided on last step and still not filling up status of "email sent" and date for more than 1 row selected. Works fine if single row selected. Kindly suggest .... Sub Mail_Outlook() Dim receiver As String Dim ccreceiver As String Dim subject As String...

@jindon Perhaps, Didn't convey msg properly.. Will break it down.. 1.Any new name entered or appended later in "2. planning sheet column C" must always write to end of list in "4. Mobile D and E" 2. If any name deleted from "2. planning sheet column C" MUST delete complete ROW in "4. Mobile...

Thanks @Luke.. Tested and works fine ... If more than 1 row is selected,can it fill up same info (email sent and date/time) pn all selected rows..or am i askin lil too much.