Previous Topic Next Topic

Sort by column A, B and print dates range

Closed
veera1 - Jun 19, 2012 at 08:31 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 28, 2012 at 06:58 PM
Hello,
I have 3 columns
emp no: Leave type Date leave taken
12 CL 02/12/2011
12 CL 02/13/2011
12 SL 03/14/2011
13 PL 03/ 12 2011
13 PL 03/13/2011

need output as
emp no: Leave type Date leave taken leave end date
12 CL 02/12/2011 02/13/2011
12 SL 03/14/2011 03/14/2011
13 PL 03/ 12 2011 03/13/2011

Please help me out to write a macro in excel to get the desired O/P

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 28, 2012 at 06:58 PM
On the same sheet?

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

Hello, Why the end to end encryption message will appear several times in a chat at different dates with no other conversation? Does that mean the chat has been deleted and activated again, then deleted again at another date and reactivated again?

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

Hello,
I needs assistance with "If "statements and criteria within the statement .

Column A has a set of start dates
Column B has a set of End dates
Column C has the If statements with criteria resulting in a date.

So here is what I'm trying to create:
IF A= B then the result in C is the B date, but if A is not = B, then result in C is B date +14 more days.

I have read many examples and can seem to be able to put all of this into one If statement.

Any help is greatly appreciated.

Thank you.

3 responses
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

Need help here please !!!

Data available : A range of data in a column. Some of the cells are blank.

My requirement : Is there any formula wherein I can copy data from the range in the column to another column in another sheet. I need to copy only filled cells. I also need to have a command which will automatically copy data by the click of one button maybe!! I tried a macro but it doesn't work.

6 responses
blank white page for website
yadaves -
ac3mark -

there is white blank page after loading [REMOVED BY MODERATOR]

help me to get it solve so that i am able to get my result ...

1 response
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

Hello!
I am working on a project at my internship and ran into some issues finishing up some of the features I want to implement. The excel is a file to track training for a specific role at the company. The first sheet (pictured below) has a list of the employees and the courses as well as a record of the date of each employees' completion of the course. What I want to implement is something to create a specific sheet for each name in each column. The person's name should be the name of this new sheet and the sheet needs to follow a specific format (pictured below as well). As you can see, this new sheet pulls the original course list as well as that employee's completion record and ...

21 responses