ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Table Help (https://www.excelbanter.com/excel-discussion-misc-queries/179334-data-table-help.html)

IHateComputers

Data Table Help
 
Everytime I try to do a data table, I get a message that says: "Error. Input
cell reference not valid."

I do not know what I am doing wrong. Here are my steps:

1. Enter titles.
2. Link initial numbers
3. Put in a series of numbers to test
4. Select on the numbers and try to complete the data table.

However, there is always some sort of error message coming up. How do I fix
this?

Jon Peltier

Data Table Help
 
Have a look at these two resources:

http://www.dailydoseofexcel.com/arch...-table-basics/
http://www.westnet.net.au/balson/Mod...MaNoCode.shtml

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"IHateComputers" wrote in message
...
Everytime I try to do a data table, I get a message that says: "Error.
Input
cell reference not valid."

I do not know what I am doing wrong. Here are my steps:

1. Enter titles.
2. Link initial numbers
3. Put in a series of numbers to test
4. Select on the numbers and try to complete the data table.

However, there is always some sort of error message coming up. How do I
fix
this?





All times are GMT +1. The time now is 03:09 PM.

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