Thank you for your comments.
Debraj Roy: Yes that is what I want to accomplish. Do you know if it can be done without
coding?
Bobhc: As I understand pivot tables they give you a summary report of your table. This file will be used by the persons monitoring the risks who will have to update...
I'll try to explain with an example. I have a risk log which is now to be used to monitor/track the risks by providing monthly updates on the project. The risks are listed going down the rows and i want to have a column for each month going across. The project is for 12 months so the fist month...
Montrey:
I did it manually.
1. Write click on the name of the query/table from the navigation pane
2. Select Export ---> Excel
3. Choose a file name
4. Select the box for "Export data with formatting and layout
5. Select teh box for "Open destination file after the export operation is...
I would like to express a big thank you to Dan who guided me in setting up an Access database. The database is stored on a shared drive. I created a query that collects the data from various tables and I then export the data to the input worksheet in the file containing the dashboard. Access...
SirJB7:
I adjusted the formula as follows to create a name range "Actual":
=INDIRECT(ADDRESS($B3,(COLUMN(Expenses)-1)*2,4,TRUE,"Sheet1"))
I added the name range "Expense" in the column formula but it doesn't work. Can you help?
SirJB7 we're getting closer. The next thing I wanted to do was to get that formula =INDIRECT(ADDRESS($B3,(COLUMN()-1)*2,4,TRUE,"Sheet1"))as a named range. I want the formula to be dynamic. As it is now I would have to copy over the formula as the months progress.
I think the trick to getting...
SirJB7: Thanks for your efforts but I wanted a formula that would do the trick instead of manually selecting the cells. The spreadsheet will be growing so i want the graph to be updated automatically.
See link. The file name is "Select every other column"
https://skydrive.live.com/redir.aspx?cid=16d0ed9ee1cb5b75&resid=16D0ED9EE1CB5B75!113&parid=16D0ED9EE1CB5B75!102&authkey=!AFA90w3_C_BAAHc
I have data in 4 cloumns. Starting from column A the numbers are: 10, 20,30, 40
I want to create a named range which will give me the first, and third numbers meaning it would give me numbers, 10 and 30. This is the formula I have:
=MOD(COLUMN(A1:A4),2). I called the named range "Actual"...
Dan:
1. For some KPIs teh targets vary by the month, for others they are fixed for the year and do not change.
2. Info for the dashboard:
- name of kpi
- value for the month
- target for the month
- target for the year
- comments
- initials of the person who has responsibility to update...
Sorry for the late response. See link to file on skydrive:
https://skydrive.live.com/redir.aspx?cid=16d0ed9ee1cb5b75&resid=16D0ED9EE1CB5B75!112&parid=16D0ED9EE1CB5B75!102&authkey=!AJgQ-3IQHwqwpoY
Dan: Me again :). So another question for you. In your database do you establish relationships between your tables? This is what is wanted of me. As I mentioned earlier each KPI falls under a balanced score card perspective. For example the KPIs named "Assets" and "Expense" are financial...
@Narayank: Thanks. What did you change so that the months are now showing? I realize though that the green point isn't in line whith the line graph. I'm wondering if it is related to the change you made
@ Narayank991:
Thanks for trying to assist me. Try this link. Copy and paste the link below:
https://skydrive.live.com/redir.aspx?cid=16d0ed9ee1cb5b75&resid=16D0ED9EE1CB5B75!111&parid=16D0ED9EE1CB5B75!102&authkey=!ANLWF325ShAm7fc
Guys I tried Narayank991 suggestion see file:
https://skydrive.live.com/?cid=16D0ED9EE1CB5B75&id=16D0ED9EE1CB5B75!102
The problem I'm having is that I want the X Axis to show the month and year from B3 to B10. It is currently showing the comments information in column A (so I deleted it)...
Ok. Glad you agree. Next question: What is the Primary key that you use in your Access Database. I'm thinking that if a table is used to enter each KPI (in my case I would have 30 tables) then I'm not seeing what would be the primary key since the tables wouldn't be related to each other. What...
Thanks Dan. I'm not verse with SQL, so I'm like a beginner, so these tutorials will be very helpful. Will start going through them now.
Next question: Do you narrate somewhere whether in a Word document or in Access itself how your file is structured or was created? For instance do you...
I just saw a video which shows that Access 2010 has what is called a Navigation Form. I believe it replaces the switchboard. I'm thinking it can be used. I'll have the list of KPIs on buttons to the left and when they click they get to view the form to enter the data for that KPI. So there will...
Dan: I just finished watching some videos on switchboards. I think that's exactly what I wanted and it can be used.
I want your opinion on something. Now remember I said there are like 30 KPIs. Now lets say there are 5 users, each updating 6 KPIs monthly. I'm trying to think how I would make...
I just love talking to you. I just keep on learning. I'll definitely look into that. I wasn't familiar with the switchboard option, and I think that does the trick nicely. Thanks a million Dan, you are quite knowledgeable.
I want to ask another question. Tell me what you think of this idea. I'm thinking to use infopath to create a user interface in sharepoint,users would use this to enter the kpi data. Have infopath send the data to access. The data will then be exported to excel from access to create the...