Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return the values in another sheet
I have 2 sheets in a workbook. I am trying to code a procedure which
will cause the value of Sheet 2 to return the value contained is Sheet 1. Each row increments by 4 (ie - B4, B8, B12, B16...) and starts at row 4, except for B5. Sheet 2 A1 = value in sheet1 B4 Sheet 2 B1 = value in sheet1 C4 Sheet 2 C1 = value in sheet1 B5 Sheet 2 A2 = value in sheet1 B8 Sheet 2 B2 = value in sheet1 C8 Sheet 2 C2 = value in sheet1 B9 Sheet 2 A3 = value in sheet1 B12 Sheet 2 B3 = value in sheet1 C12 Sheet 2 C3 = value in sheet1 B13 And so on, until Sheet 1 ends, around row 2,500. Thanks in advance for any assistance... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Used to return a worke sheet to origanan values | Excel Discussion (Misc queries) | |||
Look up in another sheet for values to return in 1st worksheet | Excel Discussion (Misc queries) | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
VBA Syntax for VLOOKUP to return array of return values | Excel Programming |