Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lynn Bales
 
Posts: n/a
Default How to add data to a column based on criteria from another

I have two columns one with a single employee id and the second column is the
employee name for several rows something like this:

1234 John Doe
John Doe
John Doe
3456 Jane Doe
Jane Doe
Jane Doe

How do I move the employee number down to coincide with its name and then
start the next employee and do the same thing without manually copying and
pasting.
  #2   Report Post  
RagDyeR
 
Posts: n/a
Default

If your data is exactly as the example you posted, try this old trick:

Select the column of employee ID's, then:

Hit F5
Click "Special"
Click "Blanks"
Then <OK
Type the Equal (=) sign
Hit the UpArrow
Hit <Ctrl <Enter
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Lynn Bales" <Lynn wrote in message
...
I have two columns one with a single employee id and the second column is
the
employee name for several rows something like this:

1234 John Doe
John Doe
John Doe
3456 Jane Doe
Jane Doe
Jane Doe

How do I move the employee number down to coincide with its name and then
start the next employee and do the same thing without manually copying and
pasting.


  #3   Report Post  
Lynn Bales
 
Posts: n/a
Default

Worked like a charm, except I didn't notice blank rows between each employee.
Is there a way to delete blank rows easily? I know these are basic questions
I'm just new to using the app. Thanks so much!

"RagDyeR" wrote:

If your data is exactly as the example you posted, try this old trick:

Select the column of employee ID's, then:

Hit F5
Click "Special"
Click "Blanks"
Then <OK
Type the Equal (=) sign
Hit the UpArrow
Hit <Ctrl <Enter
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Lynn Bales" <Lynn wrote in message
...
I have two columns one with a single employee id and the second column is
the
employee name for several rows something like this:

1234 John Doe
John Doe
John Doe
3456 Jane Doe
Jane Doe
Jane Doe

How do I move the employee number down to coincide with its name and then
start the next employee and do the same thing without manually copying and
pasting.



  #4   Report Post  
Lynn Bales
 
Posts: n/a
Default

Nevermind I found in by doing a search. Thanks so much, RagDyeR.

"Lynn Bales" wrote:

Worked like a charm, except I didn't notice blank rows between each employee.
Is there a way to delete blank rows easily? I know these are basic questions
I'm just new to using the app. Thanks so much!

"RagDyeR" wrote:

If your data is exactly as the example you posted, try this old trick:

Select the column of employee ID's, then:

Hit F5
Click "Special"
Click "Blanks"
Then <OK
Type the Equal (=) sign
Hit the UpArrow
Hit <Ctrl <Enter
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Lynn Bales" <Lynn wrote in message
...
I have two columns one with a single employee id and the second column is
the
employee name for several rows something like this:

1234 John Doe
John Doe
John Doe
3456 Jane Doe
Jane Doe
Jane Doe

How do I move the employee number down to coincide with its name and then
start the next employee and do the same thing without manually copying and
pasting.



  #5   Report Post  
RagDyeR
 
Posts: n/a
Default

Appreciate the feed-back.

And would you mind sharing your solution with the group?

Others might very well benefit from the information posted here, just as you
did.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Lynn Bales" wrote in message
...
Nevermind I found in by doing a search. Thanks so much, RagDyeR.

"Lynn Bales" wrote:

Worked like a charm, except I didn't notice blank rows between each

employee.
Is there a way to delete blank rows easily? I know these are basic

questions
I'm just new to using the app. Thanks so much!

"RagDyeR" wrote:

If your data is exactly as the example you posted, try this old trick:

Select the column of employee ID's, then:

Hit F5
Click "Special"
Click "Blanks"
Then <OK
Type the Equal (=) sign
Hit the UpArrow
Hit <Ctrl <Enter
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may

benefit!
==============================================



"Lynn Bales" <Lynn wrote in message
...
I have two columns one with a single employee id and the second column

is
the
employee name for several rows something like this:

1234 John Doe
John Doe
John Doe
3456 Jane Doe
Jane Doe
Jane Doe

How do I move the employee number down to coincide with its name and

then
start the next employee and do the same thing without manually copying

and
pasting.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining workbooks with some variable field names Bob Dobalina Excel Discussion (Misc queries) 8 May 17th 05 09:48 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Count cells based on date range in another column [email protected] New Users to Excel 1 May 5th 05 08:11 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
Can you average data in 1 column based on a range of values in another? kman24 Excel Worksheet Functions 2 November 17th 04 03:09 PM


All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"