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 |
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) |