i have some how messed up my sheet. I am generating a random number on sheet calculations that is then moved to sheet coach. From here i am moving the header from that clumn and putting the header on the sheet catcher in the box that corresponds with the number in the column from sheet on. What is happening know is i am getting #### in a lot of the columns. any help would be great.
Last edited by seccard; 06-11-2007 at 11:25 AM. Reason: title change
Do you have "Analysis ToolPak add-in" installed? You cannot use RANDBETWEEN() without it.
I have that add in turned on.
First sorry about the problems in posting. But on to the reason for the post. What i am trying to do is. on the catchers sheet i am trying to put the column header from the coaches sheet in the corresponding numbers block. For example, if 111 shows up in FB the i want to put FB in box H1 where the value is 111. for 311 the value of the column header would go into B8 and so on and so forth. Any help with this would be great
You must have extended the table. For all formulas in sheet "Catcher", you need to extend the range from A:J to A:X.
i have tried that and it did not work
Cross posted Here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks