Create link from system generated report to another sheet
can you help me on this??
i have a system generated excel report of totals... what i want is that, when i click a cell with total, it will show the breakdown on another sheet...so how can i create that links??? and how will i do that without sacrificing the run time,... Thanks...
An expert who has achieved level 3 by getting 1000 points
An expert that got 10 achievements.
An expert that got 5 achievements.
An expert who has answered 1,000 questions.
Re: Create link from system generated report to another...
The easiest way to do that is use hyperlink.
right click on the cell you want and select the hyperlink and link it to other worksheet or document you want.
one caution: if you are going to copy the worksheet to other than where it is now, you have to copy all of the attached worksheet and document. otherwise, you will get a error message.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
The easiest way to do this is to use Excel spreadsheet. This is what you need to do. Create a label at the top of each column as detailed. Add a employee to each row under Name of employee Then against each employee add the data and the formula in the relevant cell under each column.
The first column - Name of the employee 2nd column - salary rate per hour 3rd column - hours worked 4th column - gross pay (formula = salary rate X hours worked) 5th column - tax deduction 6th column - other deductions 7th column - total deductions (formula = tax deduction + other deduction) 8th column - net pay (formula = gross pay - tax - total deductions)
At the last row you can include a total for Gross salary paid, total Tax collected etc.
Once you have setup this spread sheet make a copy of it and save it as a template. You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.
Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.
There are a couple of types of spreadsheet - Depending on the size of the data you are working with - filter may the quickest option or Query report.
Your worksheet will contain all your data i.e. Customer, contact no, outstaning actions and due date - You can create a filter aon this set criteria on the due data - as less than or equal to todays date - which will only display your outstanding actions required by today or earlier.
Another option if you have installed MS Query, is to create a seperate report - again using the criteria of due date being less than or equal to today.
Producing this from your existing data is much easier than trying to re-create your data - But I can send you how I would create this sheet if the above explanation is not easy to follow - If you let me have your email address.
You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.
you can use a OLE object that is available in VB as standard object. Drag the tools to your form that your creating and it will ask for create or link existing object. so now browse to the excel sheet and embed it into the VB form or use run time for manuplating the cells and other info in excel.
I assume you are using excel? to get the new sheet auto update try this formula =sheet1!C5 into the new cell in new sheet (eg. sheet2)
whenever you update sheet one cell C5 it will automatically appear in new sheet...