ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula to fill one cell from another (https://www.excelbanter.com/excel-worksheet-functions/262574-formula-fill-one-cell-another.html)

GeorgeQ

Formula to fill one cell from another
 
I have a table of data based upon the 12 months of the year, one month per
column. Other data is added to the spreadsheet with associated month
numbers: e.g., 124 for 1 (January), 34.5 for 4 (April), etc. This other data
comes in sequentially; i.e., if there are only 3 months of data, they will
come in three adjacent cells. I need to ensure this other data is placed in
the correcy month within the table; e.g., 124 for 1 is put into the table's
January column; 34.5 for 4 is put into the table's April column; etc.

I seem to remember, a while back, there was a function(?) that enabled
filling a cell from another cell location; e.g., fill cell D6 from a formula
in cell A20, not having cell D6 reference another cell but being filled from
elsewhere. Any help appreciated.


All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com