Row-specific data to one common field

[wgd.roaming]

Good Evening:

Have a series of rows one column of which has text data (name) - only
one row will have a name, all others will be blank. How do I
determine what name is in what row and copy it to another un-related
field?

Time/Date 1

Col 1
Row 1
Row 2
Row 3 John
Row 'n'

Desired solution to copy John to another field someplace on sheet:
John

Time/Date 2 (after T/D 1)

Row 1
Row 2
Row 3
Row 4
Row 5 Carol
Row 'n'

Desired solution to copy Carol to another field someplace on sheet (as
above): Carol


Find 'John" or any other name in Rows 1 through 'n' that are in Col 1
only.

Copy 'John' to a Field someplace else on sheet - in this example, Row
1 & 2 will be purposely empty. (As the month goes by, this DB grows
row by row.) Other functions in each row block out previous data
(names) in Rows before Row 3 - thus no conflicts

In these specific examples, all other Row fields in Column 1 are
empty.

Other data in each row loads up fields in Col 1, row-by-row

At a later Time/Date, John is automatically deleted (already have
that working) from Col 1, Row 3; now Carol appears in Row 5. 'Carol'
will now be found and placed in the selected field.

I have no experience w/VBA - conditioned to use functions, nested as
may be required.

OS = XP Pro
Excel = Office 2003

Thank You!

Wayne

 

[GS]

Would doing something like this work for you?

Since each 'section' of data is headed by TimeDate*, would putting a
formula in the target cell to get the name in ColA be sufficient?

Example:
Select the entire columnA
In the namebox to the left of the formula bar,
type: '<sheetname>'!NameList
Press the Enter key

In the target cell to receive the name,
enter =IF(NameList<>"",NameList,"")

You can copy this formula into every target cell and it will only
display a name if it exists in the range named "NameList".

 

[wgd.roaming]

Would doing something like this work for you?

Since each 'section' of data is headed by TimeDate*, would putting a
formula in the target cell to get the name in ColA be sufficient?

Example:
Select the entire columnA
In the namebox to the left of the formula bar,
type: '<sheetname>'!NameList
Press the Enter key

In the target cell to receive the name,
enter =IF(NameList<>"",NameList,"")

You can copy this formula into every target cell and it will only
display a name if it exists in the range named "NameList".

Will try it tomorrow at work (sheet not "here").

Thank You for replying.

Wayne

 

[wgd.roaming]

Would doing something like this work for you?

Since each 'section' of data is headed by TimeDate*, would putting a
formula in the target cell to get the name in ColA be sufficient?

Example:
Select the entire columnA
In the namebox to the left of the formula bar,
type: '<sheetname>'!NameList
Press the Enter key

In the target cell to receive the name,
enter =IF(NameList<>"",NameList,"")

You can copy this formula into every target cell and it will only
display a name if it exists in the range named "NameList".

Sent to work this morning. Another Slam-Day in real estate <> VERY
busy - never go to try your solution. Tomorrow is another day.

Appreciative,
Wayne

 

[wgd.roaming]

Good Evening:

Have a series of rows one column of which has text data (name) - only
one row will have a name, all others will be blank. How do I
determine what name is in what row and copy it to another un-related
field?

Time/Date 1

Col 1
Row 1
Row 2
Row 3 John
Row 'n'

Desired solution to copy John to another field someplace on sheet:
John

Time/Date 2 (after T/D 1)

Row 1
Row 2
Row 3
Row 4
Row 5 Carol
Row 'n'

Desired solution to copy Carol to another field someplace on sheet (as
above): Carol


Find 'John" or any other name in Rows 1 through 'n' that are in Col 1
only.

Copy 'John' to a Field someplace else on sheet - in this example, Row
1 & 2 will be purposely empty. (As the month goes by, this DB grows
row by row.) Other functions in each row block out previous data
(names) in Rows before Row 3 - thus no conflicts

In these specific examples, all other Row fields in Column 1 are
empty.

Other data in each row loads up fields in Col 1, row-by-row

At a later Time/Date, John is automatically deleted (already have
that working) from Col 1, Row 3; now Carol appears in Row 5. 'Carol'
will now be found and placed in the selected field.

I have no experience w/VBA - conditioned to use functions, nested as
may be required.

OS = XP Pro
Excel = Office 2003

Thank You!

Wayne

My Set of Errors, not your solution I am sure. Having a problem making
it work. "Elstupedo" I might be. Definitions might be the problem.
So, please restate. And Thank You. Wayne