Thread: Newbie Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default Newbie Question

Hi,
Your question raises a lot of other questions. The numbers listed all have
leading zeros, which is not normally the case in Excel, so I guess the first
question is whether these are Text or numbers? Then the next question might
be are the only "numbers" 1-4 or can there be an unlimited number of numbers?

Thanks,

"David" wrote:

Hello Everyone. I am a complete newbie to Macro's and would ask 2 things.

1.) Does anyone have some good links to Tutorials on Macros?

2.) I have an excel sheet that has a column of numbers and I would like to
have the sheet show me what row the numbers are in.

A small example:

ROW Col.A Col.B Col.C.
001 01 02 03
002 04 03 02
003 01 02 04
004 02 03 04
005 01 03 04
006 04 03 02

I would like a new sheet created or copied into a preset sheet so it would
look like:

Col.A Col.B Col.C Col.D Col.E Col.F
01 001 003 005
02 001 002 003 004 006
03 001 002 004 005 006
04 002 003 004 005 006

Thank you for any assistance.
David