Fill Issues

[Kaziglu Bey]

I need to fill rows from information in columns in a seperate sheet.

Basically it's like this:

Row 1 & Column A = Header Row/Column

A2, B2, C2 and so forth need to extract information from a different
sheet, but from A2, A3, A4 and so forth.

This will happen in several rows.

Effectively, what I want is:

Sheet 1 A2 = Sheet 2 A2
Sheet 1 B2 = Sheet 2 A3
Sheet 1 C2 = Sheet 2 A4

Likewise, the next row will retrieve information from the next column:

Sheet 1 A3 = Sheet 2 B2
Sheet 1 A3 = Sheet 2 B3
Sheet 1 A3 = Sheet 2 B4

Suggestions? When I try to fill accross, what happens is:

Sheet 1 A2 = Sheet 2 A2
Sheet 1 A2 = Sheet 2 B2

Thanks

 

[Guest]

Try put a dollar sign in front of what you dont want to change.

Sheet 1 A$3 "This will keep the row from changing."
Sheet 1 $A3 "This will keep the column from changing."
Sheet 1 $A$3 " Will keep both the column and the row from changing."

Hope this is what you were looking for.

 

[Kaziglu Bey]

No, it gave me something other than I was looking for. I have a fe
pictures that I uploaded to help out.

Example.png shows the fill I am trying to accomplish, and example2.pn
shows where I am trying to extract my information.

It keeps doing something other than what I want it to do.

Try put a dollar sign in front of what you dont want to change.

Sheet 1 A$3 "This will keep the row from changing."
Sheet 1 $A3 "This will keep the column from changing."
Sheet 1 $A$3 " Will keep both the column and the row from changing."

Hope this is what you were looking for.

I need to fill rows from information in columns in a seperate sheet.

Basically it's like this:

Row 1 & Column A = Header Row/Column

A2, B2, C2 and so forth need to extract information from a different
sheet, but from A2, A3, A4 and so forth.

This will happen in several rows.

Effectively, what I want is:

Sheet 1 A2 = Sheet 2 A2
Sheet 1 B2 = Sheet 2 A3
Sheet 1 C2 = Sheet 2 A4

Likewise, the next row will retrieve information from the nex column:

Sheet 1 A3 = Sheet 2 B2
Sheet 1 A3 = Sheet 2 B3
Sheet 1 A3 = Sheet 2 B4

Suggestions? When I try to fill accross, what happens is:

Sheet 1 A2 = Sheet 2 A2
Sheet 1 A2 = Sheet 2 B2

Thanks

+-------------------------------------------------------------------
|Filename: example2.PNG
|Download: http://www.excelforum.com/attachment.php?postid=4982
+-------------------------------------------------------------------

 

[Guest]

I see what you're trying to do and now I know why you want to do it but for
the life of me I dont have a solution right now. My only suggestion is to
copy the section you want out of the Serial Page and do a PASTE SPECIAL then
choose TRANSPOSE and this will put the data in the format you want, however,
it wont update automattically because it is just a copy of the data and not a
formula. Sorry, hope someone else can help.

 

[Kaziglu Bey]

Appreciate your efforts anyways.

I see what you're trying to do and now I know why you want to do it but
for
the life of me I dont have a solution right now. My only suggestion is
to
copy the section you want out of the Serial Page and do a PASTE SPECIAL
then
choose TRANSPOSE and this will put the data in the format you want,
however,
it wont update automattically because it is just a copy of the data and
not a
formula. Sorry, hope someone else can help.

 

[RagDyeR]

Try this.

Say your datalist is on Sheet2, from A1 to X30.

You can enter this formula *anywhere* on Sheet1,
then drag across to copy as many columns as needed.

Then, while the row is *still* selected from that first copy,
click on the fill handle of that selection, and drag down to copy as many
rows as needed.

=INDEX(Sheet2!$A$1:$X$30,COLUMNS(Sheet2!$A:B),ROWS(Sheet2!$1:1))

--

HTH,

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

"Kaziglu Bey" <[email protected]>
wrote in message

Appreciate your efforts anyways.

 

[Guest]

I made this work but I may not be able to tell you how to do it. I used the
PASTE SPECIAL and TRANSPOSE but used it on the formula. So I created the
formulas up and down instead of side to side like you're doing and I put a $
in front of the column letter and once the formulas were filled in going down
I copied and did a PASTE SPECIAL and TRANSPOSE on the formulas and it worked
slicker than snot.

 

[Kaziglu Bey]

I worked on both answers and got yours to work first. Now I only have
one problem. I can only seem to copy 1 row at a time. If I do more
than one row I get wierd results. No worries, I figured I might take a
stab at a macro to do all the work for me. I recorded the actions, but
need it to repeat and am very rusty on macros and VB.

Here is what I have so far:

Sub Macro1()
'

Sheets("Rack B").Select
Range("A5:E5").Select
Selection.Copy
Sheets("Rack A").Select
Range("E1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True

End Sub

The sheet can stay the same for now (I did your method on sheet B as it
is currently empty), but what needs to happen is one at a time, I need
the Range to go down from "A5:E5" to "A10:E10" (it is actually much
more than 10), and special copy that information into E1, then F1, then
G1 and so forth.

How do I get the macro to move along to the next one without manually
typing it in?

BTW, thanks everyone for you help so far!!