Search results

Here is more detail. On each row, there is a name of a customer (A column) followed by 10 dates in each column (B to K). Each date represents the scheduled visits and is separted by 30 days. All the rows in the sheet follows the same format but dates are different by customer. I would like the...

Hi all, This should be a piece of cake for Excel guru. I am trying to find a way to automatically highlight cells that are closeset to today. Dates were entered across colums and need to find a way to quickly find the date that is closest to today. Please help!

I have a list of items (by rows) and have sequence of dates (in columns). I want to create a report probably using VBA. I need a list of items that meet the date restriction. For example: Apple 1/1/2010 2/1/2010 3/1/2010 Orange 1/1/2010 3/5/20010 4/15/2010 Lemon 2/1/2010 3/1/2010 In...

Thanks Luke. The code is indeed much more simple. After running the code, everything works fine but the copied data goes to a different sheet. I have four different sheet: Main, HB, RE, and DE. Instead of copying the data to HB, it goes to RE. Odd. Anythought?

Hi Suresh, This is what I have so far but this program does not work: Sub moveyesdata() ' ' moveyesdata Macro ' ' Keyboard Shortcut: Ctrl+q ' Columns("A:E").Select Selection.AutoFilter Range("C1").Select Worksheets("Main").Range("$A$1:$E$10000").AutoFilter Field:=3...

Hi Suresh, We are so close to the completion! Thank you so much for expalining each line for me. It really helps me in the long run. One last request. I want to copy only selected columns from the main sheet. The current program copy and paste all the data on the main sheet. For example, I...

Additionally, I also noticed that the current program copies all the columns from the main sheet. I would like to select the columns/information to be copied to a different sheet. Sorry for the confusion. Sub moveyesdata() ' ' moveyesdata Macro ' ' Keyboard Shortcut: Ctrl+q '...

Hi Suresh, Looking closely at your program, I noticed that it doesn't specify the name of the sheet. As I had mentioned, I need to do the same exercise to other sheets. For example, if a patient replied as "Yes," then the some selected information will be copied to a sheet "Yes", and...

Hi Suresh, Thank your for your input. I think this is EXACTLY what I need to do. As I will need to do the same procedures to other sheet, do you mind explaining the each line of your VBA program so that I can modify to create other programs. Thank you so much for your support.

Here is what I need to do. In Excel. There are rows of, say, patient information across columns. I want to copy some selected cells (like Patient Name and Date of Birth) from a row if a patient entered as "Yes" in a particular column to another sheet within the same Excel file. I can sort of...