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: one problem in the application of excel sheet
I can make out that You are speaking about creating a macro to take data from one constant updated cell and to put that data into another cell or form sheet. You will need to get precise help from a programmer on this. If you want to see a little on macros just open a sheet and checkout the help section on macros. Some macros can take many hours to write and test.Some make take months. hope this helps.
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need. goodluck!
- 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.
If you're using MS Excel it's easy, go to cell A1 and hit "Ctrl" and "C" to copy the cell, then go to cell A22 in sheet three, type in the "=" sign and paste ("Ctrl" and "v" at the same time) the info into the cell. It should look like: =Sheet1!A1
This is a PC answer, not an Apple answer, but in theory it should work for Apple too.
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
Easiest way would be to use the Undo function to work your way back to the point prior to deleting the worksheets. If you can't back up through the list that far, you could close the file WITHOUT SAVING IT, then reopen the original file again. If you have already saved the document after deleting the worksheets, you will have to restore it from a backup (you do perform backups, right?) and continue working fro there.
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.
Would you like to recover excel file password so just try
PDS Excel password recovery software this software quickly works on your
password protected Excel file and get back your original Excel file password, This
Microsoft Excel file password recovery software magnificently recover password MS
Excel file and also let you use your locked XLS and XLSX file again without creating any problem more.
With the help of MS Excel sheet password recovery software you can easily recover
password MS Excel sheet with fully previous data of your locked Excel file. PDS Excel file unlocker tool gives you free Excel unlocker software which shows you first three characters of your original Excel file password. if you want to recover whole Excel file password then you can get full version software.
Export to Excel With new release now you would get one more options while exporting data. One added format option is Excel format. If you export in this format then file would be saved in xls format. More over if you put Excel formating option to Yes then tally would automatically format the data in presentable format. Tally would automatically bold the headlines and main fields for you and format data in a good way. Take a look at excel snapshot of balance sheet exported from Tally.
The special thing here is that you can do the calculation on any amount figure or any row or column, which was earlier not possible. The only drawback which i could find was that amount figures are not right aligned which is must for numbers for easy calculation, although you can do it by selecting the amount figures and putting them right aligned.