Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi guys,
what i have is date in A1 to G1. In the following row, A2 to G2 i have data on the amount of inventory that is in the store. If there exist a value in any of the cell in B1 to B10. Let say there is a vaule 20 in cell D2. This value 0f 20 will be place in cell offset from cell D2 by a amount of offset entered by the user. Let say offset amount is 3. The value of 20 will be automatically copied to cell A3(offset 1 row below D2 to D3 and 3 column to the right of D3 to A3). Anyone could point me to how this can be accomplish? Befo A B C D E 1 MON TUE WED THUR FRI 2 20 3 After: A B C D E 1 MON TUE WED THUR FRI 2 20 3 20 <<<<<<<<Being offset from cell D2 by an offset value of 3 After: A B C D E 1 MON TUE WED THUR FRI 2 20 3 20 <<<<<<<<offset value = 1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
location of cell | Excel Worksheet Functions | |||
getting value 1 column to right of cell selected in pulldown | Excel Worksheet Functions | |||
displaying a comment only when the cell is selected | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
extracting cell location | Excel Discussion (Misc queries) |