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.
- 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.
MS Excel comes with an automatic recovery feature that attempt to reopen corrupt excel file along with repairing a file. If it fails to repair a corrupt excel file then try to open a file without repair. Sometimes this automatic recovery feature fails to open & repair corrupt excel files at this stage users can repair corrupt excel file manually.
To Manually Repair an Excel File: For manual repair of a corrupt excel file, you have to perform following steps:
Go-to the File Menu & click on 'Open'
Now select the file that you want to repair and click on the arrow next to 'open' button.
Click on 'Open & Repair' & any one method that you want to recover your data.
Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.
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
You're right - it was caused by recording a macro. When you record a macro you are given the option to store the new macro in "This Workbook", a "New Workbook" (the default), or in a "Personal Macro Workbook". It looks like you selected "Personal Macro Workbook".
The recorded macro is stored in a special workbook called "Personal.xls". This workbook is loaded every time Excel is loaded. If you don't want this workbook loaded, then just delete it or rename it.
The file is buried deep in Microsoft's application data area. On my Vista computer it's in C:\Users\frogfund\AppData\Roaming\Microsoft\Excel\XLSTART
On my Windows XP computer it's in C:\Documents and Settings\frogfund\Application Data\Microsoft\Excel\XLSTART. Depending on your computer your Personal.xls might be in a slightly different location. You might need to do a search using Windows Explorer.
If you are still having troubles finding personal.xls
1. Open Excel,
2. Open the Visual Basic editor (hit Alt-F11 or click Tools-Macro-Visual Basic Editor)
3. Click Tools-References to bring up the references dialog
4. Click on VBAProject in the list. The file location will be displayed near the bottom of the dialog box. Sometimes this might be cut off at the end, but it should give you a good idea where the file is located.
5. Click Cancel to close the dialog.
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.
I will suggest you to create small application in .net for ths which will add some value and process your data;If you want to use Excel only make a master sheet with details and use it in other excel sheets
Click on Data (Top menu), Choose Filter from the drop down list, Choose
Auto filter from the shown list. Now you get filter list on each
column. Choose the filter condition on the column(s) you want and the
data get filtered based on the condition you have given.
Have you tried a simple restart of Excel and/or your computer? That would be my 1st recommendation. If that doesn't work, make sure the font formatting for the cells is correct (this seems simple but could be overlooked perhaps). If that doesn't work you may try to repair/reinstall Excel (use the Office disc).
Let me know if you need additional help or if that doesn't work. Any additional information you can provide would be very helpful though.