excel 07

Hi, I have a spreadsheet containing Employee names, the project they've worked on, and the days. Basically, each day in a week, the employee spends a certain amount of time working on that project, say 5 (hrs). The data that I have contains this detail for all the individual days, the only...

I am running windows-7 and using Excel 2007 in Microsoft Enterprise. I am a truck driver and I have not been able to get any help on this workbook problem. I have been over this before with someone else who thought he could help but couldn’t. I gathered all the information that he asked for and...

I have an excel file embedded in a power point. (Both are 2007 for Windows running under XP). A VBA program extracts certain data and inserts it into text in the Power Point. This is working. I am trying to do something simpler which is to display a block of cells by linking them. If I use...

I need to apply link to a column values in the excel template pivot table. In my requirement of bi publisher report. My report is based on excel template. I have two sheets, one is base report(sheet 1) and another one is pivot report(sheet 2).The pivot tables(sheet 2) is created from the base...

Friends, Can anybody tell me how to Run an XLSM file always in full screen even though the user pressed the escape button? Any help will be highly appreciated.

I have a worksheet and I am using an "Auto Present" macro on it. But that macro is working very slowly, Slowly means it is taking more than 5 seconds to process even though other macros are taking only fraction of a second. I don't know why this is so. So, friends My actual requirement and code...

Friends, Good day to everyone ! I need a macro code for the following problem. I have an excel sheet and on that I am using drop down menu in Cell U8 to U357 (Data Validation). In this work sheet, If I selected the value "A" from the drop down menu, I want to Display a message box with a...

<tbody> Date 1/1/14 7/1/14 14/1/14 21/1/14 28/1/14 Today Date 13/12/13 Sold 6 2 8 9 10 Bonus 2 1 3 3 3 Total ??????? Total 8 3 11 12 13 </tbody> Hi Guys and Girls, I am after a formula for the above sample table. In the total window with...

Hi, I am setting up an excel file to use as a database (MSAccess currently not an option) with a data entry sheet and a table sheet. The data entry sheet is set up to use 8 columns per day times 365 days (data is entered in columns B to DHQ). I have set it up like this as it is the currently...

Hi, i have the vba code below which lists file names in a chosen folder in the first column of an excel worksheet (worksheet 2 in this case), does anyone know how i can adapt this code so that it doesnt pick up and report on any files that begin with a '~$' ? Occasionally it picks up files...

Below is a handy bit of code in Excel 2007 which simply lists all the files it finds in a folder in the first column of the worksheet, I'd like to somehow adapt this code to just 'count' the types of files in the folder so that it looks to a folder and reports back (see below 'desired result'...

Hi, Below is the starting code of a macro in excel 2007 which does a find and replace for a word document. It is currently set up to allow the user to navigate to a file, which works fine...but i would like to be able to give the user the option to either navigate to, or, just use the active...

Hello, I have a handy macro in excel 2007 which can perform a 'find and replace' on word documents depending on criteria placed on the excel worksheet. Currently, the macro is only searching through all docs in the initial folder it is navigated to search through and the first level of...

I am trying to open my mail merge document straight from my data source in excel with a button. I have tried to type a code with help from several forums but I am not having any luck. I recieve a Run Time error424 when I run the macro. I am using Excel and Word 2007. The line that the debug...

Hi! Okay so I have created a revenue and production tracking worksheet in Excel. Each month booking forms that are signed off within that month are entered under the sales rep's name with details such as the start and end date of the booking, the financial breakdowns of the bookings, etc. As...

Hello all, I'm working on a excel sheet to design control panels and as part of this program I have been told to insert pictures of the components (Preferably to match up with what gets sent to the customer) it was also required that I avoided the use of macros, VBA and any add-ons. I have...

I apologize in advance for any noob poster mistakes - I am very novice, trying to edit an Access database. I am trying to upload .xlsx data by changing a hard-coded workbook and worksheet name to a more flexible one. The worksheet name includes a date that will be changing every time this is...

Hello everyone! I have a dynamic chart. Simple column graph. That's all working as expected. Now what I would like to do, is to color the column red if the score for that week is below X-value. Let's say 85%. So, if the score for the week in cell B5: >=$B$5 Green <$B$5 Red How can I do...

Can some please assist me with the following: I've tried a bunch of code which has somewhat helped but can't seem to get what I'm looking for. Note: Each Row specified is Actually its own sheet with the same header. Sheet1, Sheet2, Sheet3, Sheet4, & Sheet5 Expected Outcome: Name -...

I'm trying to write a formula that will count the number of locations within a specific size that have net revenue margins within a specific range. I get an error on the formula below so I know it's wrong but hopefully you can get the gist of what I'm trying to write: Thanks! =IF(AND('AE...