automatic offset cell location when there is a value in a selected cell.
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 |
All times are GMT +1. The time now is 11:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com