excel 2007

HI I have added 2 combo boxes to a spreadsheet. The 1st is used to select a BU and the second is a dependant drop down for selecting a sub BU based on the BU chosen in combo box 1. I have used this sort of set up before and it has worked fine. However, ComboBox2 doesn't seem to display the...

Good Morning, I am new to this forum and a little bit new to Excel 2007. I am struggling to come up with a formula to SUM a column with multiple entries in a single cell where other cells have single entries. The values i require are costing therefore £ values in each column require to be...

Hi there, First of sorry for my poor English. Am no native speaking and writing person. Thx in advance for any assistance. I am forced to make this in Excel 2007, so it has to work in that. I have to adjust a sheet that is used to store the expected hours on a project. People fill in their...

Hi All Using Excel 07 I'm setting up a macro enable workbook which produces results (up to 13) based on a number of criteria. The macro currently unhides the result number of sheets that already exist, so if there's 4 results, "All Results", "Result 1", "Result 2", "Result 3" and "Result 4"...

EXCEL 2007. Time, date, load fields. I have entered data for every hour, 24 rows per day. I can sort on date field, nice line up, all 24 rows for 1st date, 24 rows for 2nd day, etc... Now when I sort on time, in order to see 1st hour's data for each date, I get screwy data. Just using sort...

HI I have a userform that contains text boxes, combo boxes, data pickers and list boxes. There are 2 list boxes, both of these are set up to allow multiple selections. I have code that loops through each control in the form to extract the data to a worksheet. This works fine for everything...

I'm having a problem getting a VLOOKUP to work where Excel thinks the times 3:45 PM and 3:45 PM don't match. Both are formatted H:MM AM/PM. When I evaluate the formula it shows that one is 0.65625 and the other is 0.65624999999999. The one it marks as 0.65625 is generated from the formula...

I have a data set with unique id numbers down the left hand colum and dates (week commencing) across the top. For each unique ID I want to sum the data if it falls under a specific month. So for example I want to say for the unique id number, if the date contains the month of october then sum...

I have a schedule for employees that is set up like a Gantt chart, where the time that the are scheduled to work is highlighted across the row. I am looking for a way to automatically populate things like lunch breaks and manager on duty shifts. My co-worker has used a schedule in the past...

Hi I've been trying to use index match match in vba and I just can't get it right. I've tried a couple of ways. The 1st thing I tried was: Me.Controls("POinv" & x).Value = Application.Index(wsP.Range("B:L"), Application.Match(Me.Inv2.Value, wsP.Range("K:K"), 0), Application.Match(wsP.Cells(3...

I am looking for a way to automatically fill the cell color of one cell based on a range of times represented in another cell. So for example, I have column B which lists employee's schedules in the format of 8-4, 9-5, etc. These values are being referenced from another worksheet that contains...

I have a weird problem printing multiple worksheets, all of which contain charts only. If I try to print all the pages at once by selecting all 10 worksheets (21 pages total), they seem to get broken up into batches. I can't see any logic to it. This happens no matter which printer I am...

Hi, I have a user form in which I enter a date via a textbox. The code behind the form stores the dat in a specific cell. Later I read back the date information from this cell and notice that excel gets the date wrong. When I enter the date 6 september 2016 (actually I key in 6-9-2016) the date...

Hello all! I found a macro on these boards for tracking attendance with a barcode scanner, but the code does not seem to function in Excel for Mac 2011. Here is a link the the old thread with the macro I'd like to use: Need Help with an Attendance Sheet Using a Barcode Scanner - Page 2 I...

Good Morning, I have two Workbook's Quick Test1.xlsm(Source) & Test.xlsm (Destination) , i would like to have a button on the Test.xlsm Sheet "Master" that once clicked prompts user to search for a client name, it will then search the closed workbook Quick Test1.xlsm Sheet "Companies" for the...

I am trying to copy a range across workbooks however I have formulas in the destination workbook that when I copy range across get deleted below is my code how would I implement the "PasteSpecial xlPasteValues" ? thanks very much for your time. Code: Sub ShowAll Dim mydata As String mydata...

Hi people, I'm trying to copy formatted text from Microsoft Word .doc but it isn't works. I did using the code below: ' Extract text Application.DisplayAlerts = False Application.ScreenUpdating = False Dim objWord As New Word.Application Dim objDoc As New Word.Document Dim DocFile As String...

Private Sub Worksheet_Activate() Sheets("sheetname").PivotTables("PivotTablename").RefreshTable End Sub Dear sir I have used this vba code On a worksheet to auto refresh the pivot table on another sheet . It was working But I have 2 more worksheets in my inventory , i am unable to do...

Hi So here is the situation. I have an excel 2007 spreadsheet that has a column with dates that I need to sort from oldest to newest or vice versa. Here's what I did so far: 1. Did Text-to-Column > Finish 2. Even after step #2, I was still unable to sort them from oldest to newest. 3. So...

I have a data base that has over 200k rows. They are individuals that have been termed from the company. The issue is that from multiple reports I merged together, I have the same Employee showing up multiple times based on the fact the reports that the data came from shows him up more than...