Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Populating Columns - VBA macro or function? 1

Status
Not open for further replies.
yorrick

yorrick

Technical User
Jan 3, 2002
58
AU
Hi,

got a spreadsheet that looks like

Harry 23
34
33
45
Larry 23
12
45
12

What i want is Harry to be next to each of his scores. So it looks like

Harry 23
Harry 34
Harry 33
Harry 45
Larry 23
Larry 12
Larry 45
Larry 12

anyone any thoughts?
 
Sort by date Sort by votes
Select the names range, and do menu command Edit/Goto/Special/Blanks and then type "=" UpArrow Ctrl-Enter.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
 
Upvote 0 Downvote
Help!!

i used to get this post to work but now after I've selected the range and done
menu command Edit/Goto/Special/Blanks
press "="

and then uparrow

it selects Formulas in the Goto Special Menu! and therefore when I do ctrl-enter it simply says "no cells found" and does nothing!
 
Upvote 0 Downvote
ignore me -worked it out - talking jibberish!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Use 2 columns in Detail Section of report 1
Replies
8
Views
805
TrekBiker
TrekBiker
techguy2010
  • Locked
  • Question
Excel macro to send e-mail to multiple agents with a different body for each 1
Replies
3
Views
734
techguy2010
techguy2010
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
1K
combo
combo
EFFEY
  • Locked
  • Question
I have three columns in excel named 1
Replies
5
Views
516
EFFEY
EFFEY
OCM
  • Locked
  • Question
Compare two columns
Replies
2
Views
2K
OCM
OCM

Part and Inventory Search

Sponsor

Back
Top