Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Issues
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 -- Kaziglu Bey ------------------------------------------------------------------------ Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086 View this thread: http://www.excelforum.com/showthread...hreadid=558691 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Issues
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" wrote: 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 -- Kaziglu Bey ------------------------------------------------------------------------ Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086 View this thread: http://www.excelforum.com/showthread...hreadid=558691 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Issues
No, it gave me something other than I was looking for. I have a few pictures that I uploaded to help out. Example.png shows the fill I am trying to accomplish, and example2.png shows where I am trying to extract my information. It keeps doing something other than what I want it to do. Scott Wrote: 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" wrote: 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 -- Kaziglu Bey ------------------------------------------------------------------------ Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086 View this thread: http://www.excelforum.com/showthread...hreadid=558691 +-------------------------------------------------------------------+ |Filename: example2.PNG | |Download: http://www.excelforum.com/attachment.php?postid=4982 | +-------------------------------------------------------------------+ -- Kaziglu Bey ------------------------------------------------------------------------ Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086 View this thread: http://www.excelforum.com/showthread...hreadid=558691 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Issues
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" wrote: No, it gave me something other than I was looking for. I have a few pictures that I uploaded to help out. Example.png shows the fill I am trying to accomplish, and example2.png shows where I am trying to extract my information. It keeps doing something other than what I want it to do. Scott Wrote: 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" wrote: 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 -- Kaziglu Bey ------------------------------------------------------------------------ Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086 View this thread: http://www.excelforum.com/showthread...hreadid=558691 +-------------------------------------------------------------------+ |Filename: example2.PNG | |Download: http://www.excelforum.com/attachment.php?postid=4982 | +-------------------------------------------------------------------+ -- Kaziglu Bey ------------------------------------------------------------------------ Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086 View this thread: http://www.excelforum.com/showthread...hreadid=558691 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Issues
Appreciate your efforts anyways.:) Scott Wrote: 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 ------------------------------------------------------------------------ Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086 View this thread: http://www.excelforum.com/showthread...hreadid=558691 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Issues
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" wrote in message ... Appreciate your efforts anyways.:) Scott Wrote: 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 ------------------------------------------------------------------------ Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086 View this thread: http://www.excelforum.com/showthread...hreadid=558691 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Issues
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" wrote: Appreciate your efforts anyways.:) Scott Wrote: 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 ------------------------------------------------------------------------ Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086 View this thread: http://www.excelforum.com/showthread...hreadid=558691 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Issues
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!! Scott Wrote: 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 ------------------------------------------------------------------------ Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086 View this thread: http://www.excelforum.com/showthread...hreadid=558691 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) |