How to Build an Excel-Report ?

Hi,

I am Martin from Hamburg and wonder how I can create an Excel-Report.
I want to create an Bingo-Card Generator in Excel. Thought and Done, but 
only the functions of generating the bingo-values by randome and deleting 
field by random depending on the system variables like number of players 
etc.
So, I have build up one Excel-Worksheet with the right values. In each 
cloumn are the whole values for one bingo-card.

Now, I wonder how to print them. But I cannot find any Report function like 
in Access.

May anyone can help me, how do I get my generated values in an printable 
report format ?
Is that possible ?
Thanks.

Regards
Martin 


0
marmos (1)
12/22/2004 1:05:14 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
357 Views

Similar Articles

[PageSpeed] 3


"Martin Meier" wrote:

> Hi,
> 
> I am Martin from Hamburg and wonder how I can create an Excel-Report.
> I want to create an Bingo-Card Generator in Excel. Thought and Done, but 
> only the functions of generating the bingo-values by randome and deleting 
> field by random depending on the system variables like number of players 
> etc.
> So, I have build up one Excel-Worksheet with the right values. In each 
> cloumn are the whole values for one bingo-card.
> 
> Now, I wonder how to print them. But I cannot find any Report function like 
> in Access.
> 
> May anyone can help me, how do I get my generated values in an printable 
> report format ?
> Is that possible ?
> Thanks.
> 
> Regards
> Martin 
> 
> 
> 
0
ST (10)
12/22/2004 1:49:03 PM
Reply:

Similar Artilces:

Sorting in excel charts
I have a chart in excel 2007 I want to sort rows 1-5 decending and rows 6-11 decending but when I select just that much and click to sort it re-hilights all of the data in the blue bounding chart selection is there a way to only sort a few rows in an excel chart I cannot reproduce the problem. When I select 5 cells out of 11 in a column Excel 2007 does not automatically change the selection. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu ...

how do i add a quadratic trendline to excel
i need to add a trendline for a quadratic equation for my math project but it seems to me that its not available is there a way that i can do it? im using windows XP home edition Chart|Add Trendline select a polynomial of order 2 then click on the Options tab and request that Excel display the formula. Alternately =LINEST(ydata,xdata^{1,2}) will give you the quadratic coefficients in a worksheet. Jerry moseichuk007 wrote: > i need to add a trendline for a quadratic equation for my math project but it > seems to me that its not available is there a way that i can do it? > im...

reports in "cash flow" with (red) expense amounts
I can generate the rpt ok, but some of the categories come out in red and parens, showing they are backed out. I don't want them backed out! I have tried re-entering, but that's no help. Probably some boxed is checked, but I can't imagine what so can't find it. Help in product was no help, and I've read my MONEY 2002 FOR DUMMIES to no avail, too. Hoping someone here can help! In the cash flow report, Income will be positive. Black no parens. Expenses will be negative. (Red w/ parens.) Is this what you are seeing? This is because Income is cash flow in--like the r...

Excel VBA Macro
Hello, I want to check if this statement is correct in excel VBA: Const DataPath = "U:\DATA\PROGRAM\" Workbooks.Open Filename:=DataPath + "MOPS.XLS" Please advise. Thanks Sheela Sheela, It appears correct. Although personally I would use & instead of + when concatenating. Sheela wrote: > Hello, > > I want to check if this statement is correct in excel VBA: > > Const DataPath = "U:\DATA\PROGRAM\" > > Workbooks.Open Filename:=DataPath + "MOPS.XLS" > > Please advise. Thanks > > Sheela -- Cheers Andy...

Excel password #3
I forgot the password for my excel file. I have tried some programs such as Accent Excel password recovery, advance office password recovery. Neither did work. Sang. Well, your options are to either remember the password or find a recovery program that works for you. No guarantees - if you picked a really good password it will be tough to break it. -- -Ben- Ben M. Schorr, MVP Roland Schorr & Tower http://www.rolandschorr.com http://www.officeforlawyers.com/outlook.html Author: The Lawyer's Guide to Microsoft Outlook 2007: http://tinyurl.com/ol4law-amazon "Sang-Wook...

Excel caused an invalid page fault in module EXCEL:EXE at 0137:300
w'95 obtain this error message when opening Excel. However , if I link to the internet it will then open without a problem. Can anyone advise how this can / should be rectifyed? Thanks dgb Hi do you get this error in all cases?. If yes probably a re-install could help -- Regards Frank Kabel Frankfurt, Germany dgb wrote: > w'95 > obtain this error message when opening Excel. > However , if I link to the internet it will then open without a > problem. Can anyone advise how this can / should be rectifyed? > Thanks > dgb ...

Question on Excel 2002
I am attempting to use objects from the control toolbox (e.g. chec boxes), but I do not appear to have the "format control" option when right click on the object (an option available on the previous versio of Excel). Does anyone know if this can be added or alternate way t select this, or if such functionality now requires VBA code. Thank for you help -- case ----------------------------------------------------------------------- caser's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1652 View this thread: http://www.excelforum.com/showthread.php?thr...

excel wont open file #2
I am trying to open a excel file, but a message comes up saying th file is corrupt ,is there anyway i can open i -- Message posted from http://www.ExcelForum.com ...

How do I change the size of Value Axis Title box for an Excel Cha.
The title box cannot be sized. I must reduce the font to very small to prevent truncating the title. I would have thought I could drag the box to the size I wanted but I do not get the chance to do so. Instead of a Title, you can use a Text Box: Select the Chart Type the text you want in the Title Press the Enter key A text box will appear in the centre of the chart Drag it to the location you want it, and format/resize as desired. If you prefer, you can link the text box to a worksheet cell, and display its text: Select the chart Type an equal sign Click on the cell you want to link Pr...

Date filter in AFA reports
It will be important to add a date filter on AFA reports. All customers have this suggestion. Thanks ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=d6bc6c96-14cd-4660-a7a...

how to use excel to do random sampling
I have a data set of 30 numbers. I need to use excel to draw 50 random samples of size 5 and then compute the mean for each sample. How do I do this? if your sample is between a1:a30 and your sample between 0 & 1. in B1 type =Rand(a1) and copy and paste the formula to B30. if your numbers are larger than 1 then use =Rand(a1)*100. Rand() gives you random sample. Nikki "stats" wrote: > I have a data set of 30 numbers. I need to use excel to draw 50 random > samples of size 5 and then compute the mean for each sample. How do I do > this? With, or without, ...

Deleted timesheet resists in Reporting DB
On the one hand I hope for all of you that you can’t answer my question since you never ran into it. On the other hand I hope that anyone has an idea what I could try: I have the situation that a timesheet was created at some day. A few days later this timesheet was deleted. We don’t know exactly when that was done, but it could be during a timeframe when disk space was full. The issue is now, that we have the old timesheet data in Reporting DB, but no information for that timesheetUID in Published DB. When resource create a new timesheet for that period, there is an error in...

CListCtrl in report mode and column header
Hi, I would like to have a CListCtrl in report mode with columnheader but I would like the column header to be transparent and without displaying separators. How can I do that ? mosfet a �crit : > Hi, > > I would like to have a CListCtrl in report mode with columnheader but > I would like the column header to be transparent and without displaying > separators. > How can I do that ? Or same question : HOW CAN I CHANGE COLUMN HEADER COLOR ? "mosfet" <richom.v@free.fr> wrote in message news:45d45ced$0$26337$426a74cc@news.free.fr... > Hi, > > I wo...

sql server report 2008 export options
I would like to know know what are the options of exporting in sql server reports 2008: I would like to export a report with about 10 sub or linked reports to a format that you can work with a table of contents. From looking on the web site looks like my best option is to export to Word. Are there other export options that would work like exporting to xml and creating a table of contents? If not, how would you accomplish this task using Word? ...

Excel Files Won't Open From Shortcut
The title's misleading but I couldn't find a way to express it succinctly. If I have 2 Excel windows open, with one or more workbooks within each window, and I click on an Excel file-name in Windows Explorer or on a shortcut to an Excel file-name, nothing happens. If I close both Excel windows and try it, the file will open. Or if I go to Files, Open, and Browse to the file name it will open. This is both new and a pain in the rear. As recently as 3 months ago I could open six or eight Excel files at the blink of an eye, from Windows Explorer or from shortcuts. What change...

multi formulas in excel
Please help, I'm trying to show margin or profit on a spread sheet the formula I am using example: =C4/C3 Where c4 equals 300.00 and c3 equals 100.00 answer is 33.3% but what I want is the inverse or 66.7% I have tried =C4/C3-1 but this gives me -66.7% I need the answser to be positive, example 66.7 =1-C4/C3 HTH, Bernie MS Excel MVP "the_catster" <the_catster@discussions.microsoft.com> wrote in message news:0710DB8F-C669-4BFF-99F2-93E46850ACEA@microsoft.com... > Please help, I'm trying to show margin or profit on a spread sheet the > formula I am using e...

find instances & report neighboring values
I am attempting to sub total amounts by month for a fairly large number of items. I would like to have excel find all instances on one date (Oct-05 or Jan-06 for example) and report all of the values in the cell neighboring each (ex, if I am adding the Oct-05 values, I want it to find the Oct-05 in d-4 and d-8 and report the value for e-4 and e-8). Once the values are reported, I need the values added . I don't care to see each value but I do need the total to be seen. =SUMIF(D:D,A1,E:E) where A1 hoilds the date to test for. -- HTH RP (remove nothere from the email address if mailin...

Office 2011 Excel Beta 3+ cell right-click context menu won't work
I've been running the beta versions of Mac Office 2011. Up until Beta 3, I could right-click in an Excel cell and get the context menu as expected. Now, starting with Beta 3 and into Beta 4, I have lost that functionality. Has anyone experienced this? I can't find a preference/setting that would bring this feature back. This is very frustrating and I can't figure out what may have changed to cause this. On 7/14/10 10:17 AM, in article 8980e35e-864d-491e-a5d9-d11a494da5aa@u4g2000prn.googlegroups.com, "Michael Barry" <4mjbarry@gmail.com> wrote: > I've be...

Help! Excel freeze the whole thing when start.
Excel problem in my office has been constantly bugging me. Now that one of the computer can even start Excel, when we try to start it, it gives something like "resource is not enough" message and then just dies there. We can even fix it by removing it and reinstall it. Any one has idea deal with this? Many thanks in advance. Pete Try cleaning up your windows temp folder. And if that didn't help, try searching for your *.xlb file. It's where excel stores your customized toolbars. Windows Start button|Find|files check out the size of that file. If it's huge, try r...

Excel guru's Urgent help
I have a bunch of charts created in Excel97 that are driven from pivot tables on another sheet. When the workbook is opened in Excel 2000 everything works fine except when you change criteria causing a macro to change the pivot tables, the source data range does not automatically reset as it does in 97. I have to manually click on Source Data, click in the pivot table, and the range is reset, fixing the chart. I don't know much VBA and I would like to hang a sub at the end of the macro that would automatically reset the source range. Can someone help with the script? I cr...

Import information to Excel
I have a link to transfer data from an internet resource into my excel sheet. I can only grab block of information from the webpage. Is there a way to specify the inforation I want instead of having to link the whole block of data? The reason I'm asking is when I link a block, several column of data will be imported to Excel in one column. I use "Text to Columns", but that won't help next time I refresh the data. Thanks. Jason in <get external data> if you want the tables only you can specify. If you want only one table then also you can specify. Only proble...

Can you create a check box or radio button in Excel?
Yep. Try showing the Forms toolbar. There's a checkbox and option button on that toolbar. The control toolbox toolbar also has its own versions of these, too. sf49ers wrote: -- Dave Peterson Dave, Thank you very much for your help. "Dave Peterson" wrote: > Yep. > > Try showing the Forms toolbar. There's a checkbox and option button on that > toolbar. > > The control toolbox toolbar also has its own versions of these, too. > > sf49ers wrote: > > -- > > Dave Peterson > ...

View/Print Individual Reports
Here is what I have: I have a database for tracking therapy clients. Client data is in one table. Therapy progress notes are in another with a one-to-many relationship. I have a form w/ subform set up to receive the data. I have a query set up to tie the two tables together and feed into a report. (Tables/Forms and Queries all do what I want them to properly) Right now, the report contains data from every client and progress note. What I want is to be able to place a button on the subform for the progress notes, so that when it is clicked it generates the report with just that...

Counting in excel #3
I have a workbook of several sheets which have hundreds of rows of data, and I want to make a summary sheet which takes data from one column of each sheet. In the summary sheet I want to see how many items are in the sheet within a given range. For instance the table is titled gains The ranges are 1-500, 500-1000, 2000-5000, 5000-10000, and 10000+ I'm pulling the data from column N of sheets titled NE NW SE MW SW and GL. What counting formula could I use? I think I'd add a new worksheet and then copy each of those column N's into one giant column in that new worksheet. ...

Excel and Access Linking
I am interested in linking the two together for a project at work. I work for a construction company and I need to keep track our employees and the work they perform. I also need to do this for our subcontracted work also. We have about 95 clients and about 15 different crews in-house. I am looking for some good reference books or web site linkings on Access and Excel. I enjoy this forum nad have found many useful topics. --- Message posted from http://www.ExcelForum.com/ ...