Pages

Search

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?

Excel Help Forum - Excel Programming / VBA / Macros: File System Object Issue.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
File System Object Issue.
Greetings: The code below is used to copy a folder and all its contents. It works great and is quite fast when run across a local drive, and even when run across a shared drive close to me in the network tree, if I'm using the right term. The problem is that when I run it across a shared drive...
Subscribe to: Posts (Atom)