Helping people with computers... one answer at a time.
Read the article that everyone's commenting on.
Hi am a newbie to VBA here, and just try to create a little payroll system. my aim is when a employee hrs is enter via form it would load the relvant book do calculation of i.e (hrs*Rate) and return it (Value)and display in on a form. looking for your help.
please help me
how to create Paste Link in the excel using vba code
How do I link multiple cells, from several worksheets, to one cell in my summary worksheet, in Excel 2002.
Using links between workbooks is known to be problamatic. You might look into LinkedCells at www.LinkedCells.com. It offers a very simple add-in that lets you share your Excel data with others in a publish/subscribe manner.
I am trying to link many workbooks to a single workbook. These workbooks are identical but in separate folders. When I copy and paste the template to the different folders, the path of the centrally linked workbook changes to match the path of the pasted templates. I want to keep this centrally linked workbook in a single location. How do I essentially freeze that path?
how to create Link from a cell in different worksheet excel using vba code or function.
I want to know that, there are more than sheet from Month Name such as Jan 08, feb 08,, I want to do that In report cell, when i do entry in a cell of this Sheet name, then it show full data of those Sheet.
I want to link a cell in one worksheet to a cell in another so that when I update one, it updates the other automatically. This is not http links, just a link that keeps all linked cells identical. HELP!!!
I want to know that, there are more than sheet from Month Name such as Jan 08, feb 08, I want to do that In report cell Entry the Data and it goes into different sheet.
Okay, so I tested the "Paste Special" option and it works!
I'm trying to create one spreadsheet where I enter data on a daily basis, but I only want to enter this data in one row.
I would like to link another workbook to this spreasheet that keeps historical data.
In other words, when I enter numbers into "Spreadsheet A" on Day One that same info will appear in "Spreadsheet B", Day One.
On Day Two I will write over the info from the previous day on "Spreadsheet A" and that info will appear in "Spreadsheet B" on the next row for Day Two, and so on.
Does this require an "If,And" condition?
i have ten worksheets. each work sheet has 10 different peoples name adress age phone numbers. I have one summary worksheet as well. i need a formula to find oldest person's name age and address from each worksheet and automically put into summary sheet. Please advice.
To post a comment on "How do you link cells in different Workbooks in Excel?", please return
to that article's main page.
Question? Ask Leo!
The Tip Jar: Buy Leo a Latte!
By Date |
Business Card |
Advertisements do not imply my endorsement of any product or service.
Copyright © 2003-2013 Puget Sound Software, LLC and Leo A. Notenboom
Ask Leo! is a registered trademark ® of Puget Sound Software, LLC
Terms, Conditions & Privacy
Product Reviews, Recommendations and Affiliate Links Disclosure