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.
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.
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
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.
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.