Pages

Search

Excel Help Forum - Excel General: Equation(s) That Will Automatically Find Bad Data And Correct It.

Feed2Mail notification - new post on Excel Help Forum - Excel General
Equation(s) That Will Automatically Find Bad Data And Correct It.
On a weekly basis my team has to run a large excel export from a database. With thousands of data rows and columns, most of the information is correct, but some of the information is not and must be manually located by our team and manually corrected in each cell before submitting it to management....

Excel Help Forum - Excel Programming / VBA / Macros: Help!!!

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help!!!
Hi, I am trying to copy text from multiple specific cells and send the text to another sheet in a spicific cells. Also, once its done coping and sending that the text was copied orginally would bet delted automaticly. At first i used a button and code. (didnt work) then macro(didnt work) so im...

Excel Help Forum - Excel Charting & Pivots: Configuring Pivot table to display certain data

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Configuring Pivot table to display certain data
Hi: Please refer to attached sheet. I am using the pivot table as shown. Column K shows Week# Column L shows the total hours worked in that week. I need to see if it is possible to configure the pivot table so to display weekly data only which has over 40 hours. Please help.

Excel Help Forum - Excel Programming / VBA / Macros: Help to return only first 12 characters when a cell contains specific text

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help to return only first 12 characters when a cell contains specific text
Hi Guys, I have a spreadsheet which has some unnecessary characters added onto the end of some records which I need to remove. I am essentially trying to ensure that if a Cell in column A begins with (or contains) "PR" that it only returns the first 12 characters. Other records in column A may...

Excel Help Forum - Excel Programming / VBA / Macros: Trouble with an algorithm. Multiple data sets based on date.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Trouble with an algorithm. Multiple data sets based on date.
I have looked into several different ways of solving this and have not been able to identify a solution as of yet. I have attached an example of the kind of data sets that I am working with as well as an example of the algorithm which I am currently using to analyze these data. The information is...

Excel Help Forum - Excel General: viewing pictures in excel

Feed2Mail notification - new post on Excel Help Forum - Excel General
viewing pictures in excel
This may be a simple issue but it has me stumped. Suddenly when I open excel files, pictures are no longer displayed. Some had been inserted from a tiff file but others had been pasted in. For the inserted pictures there is the message: "The linked image cannot be displayed. The file may have been...

Excel IT Pro Discussions Forum: Comments don't stay with row in external data table upon refresh

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Comments don't stay with row in external data table upon refresh
I have a table of data obtained via query from an external ODBC data source. I've added a column at the right where I make comments. When I refresh the table the comments do not stay with the original row. Can anyone explain why and how to fix this?
Subscribe to: Posts (Atom)