| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing entire column of data from another sheet.
I want to plot a column of data but need to define easily what column
to chart. I have a worksheet called data with each column representing a year and each row representing a day, so 365 rows. The Year is in ROW 1 and the data is in rows 2..366 On another sheet called Charting I have A1 = to the year of data I want to plot. What do I need to put in A2..A366 so it pulls in the correct data based on the year in A1? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to hyperlink entire column in Exel sheet | Excel Discussion (Misc queries) | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
| Find and REPLACE within a selection, or column- not entire sheet/. | Excel Worksheet Functions | |||
| referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
| Referencing an Entire Sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
