Hi All
Im using Excel 2007. Is there a way using code to detect which columns are filtered? I have a piece of code that I need want to run when the column with column heading Supplier is fil...
Hello all,
I have an exciting quesion regards rows:
I have a sheet which has a lot of summary info from rows 1 to 9.
I then have four pieces of information repeated from cell ten onwa...
Hi
I was given the following procedure to check whether the time right now is betwwn 11:00 hours and 14:00 hours. How would I update it to check between the times 11:23 and 14:34
Sub che...
I'm trying to get a count based on col A:A (item#) and AB:AB (manager)
I'm NOW convinced that COUNTIF won't do it.
I'd appreciate some help
Thanks
Greetings,,
I have a problem with coding a VBA function. I am using Excel 2003 and have not done any serious programming for years (Pascal, though I was using Basic and Fortran on a mainfra...
I need to find a way to programmatically import xml documents to multiple excel worksheets. basically, i could import the xml documents into datatables in a dataset. my problem is that i nee...
Hi,
Have some end users with what I would consider large excel files (34MB). One became corrupt but I managed to recover the data. Another one gave an error that it was locked by the user b...
I have a spreadsheet with three worksheets.
All 3 worksheets start with the same 2 columns of Surname | Firstname. The worksheets are called 'Users', 'GPO', 'Proxy'.
In the 'Users' work...
I have a excel which has two sheets. I have attached the excel. In first sheet and first Cell there is a Validation List which contains numbers "1,2,3,4,5" when a user selects a number I want ...
I have an excel file I need to import to our system. Some of the present entries are 11 digits and some are 12. I need them to be 12 characters long all across the file, if its 11, I need to p...
Hello,
I have a DSUM formula. I'd like to reference a wildcard date in its criteria.
The 'database' range includes a column [leaddate] of dates formatted to dd/mm/yyyy. I'd like the crit...
I need some assistance in creating a Macro in an Excel Spreadsheet which will save the file to a specific location each time it is opened. I would like the Macro to include an automatic overw...
Thank you for looking at my question,
I have a worksheet containing production data for 2008, Columns: A1:A1000 = Week, B1:B1000 = Date (in the format dd/mm/yyyy), C1:C1000 = Shift, D1:D100...
I am developing an Excel workbook that can either be run in the normal way frm Explorer, or instantiated from an external application which then posts data into it. In the latter case, I need ...
Hi
As part of Vista my general default mail program is Windows Mail. What do I change in excel to achieve the same so that I can use 'send to with attachment'. I think excel's current defau...
I am trying to generate a report on sheet 3, that will look at Sheets "June" and Sheets "August" and list only the amounts people have paid against there June debts. To elaborate, the Sheet "...
See Attached: In Sheet1 I've created 2 drop down boxes. How do I get the data from the Data Table sheet to populate on sheet1 (based on the drop down box selections)? Sheet3 has the unique ...
Hello,
I have 4 columns in an excel spreadsheet. I want to rearrange the cells.
Below represents the four columns in the current layout of the first two rows:
sink("small.bin.PDand_Q_su...
I am looking for someone or something to go through 900-1000 rows in excel Column A and categorize them in about 5-10 categories in Column B. This can be done with a script or manually. as I w...
I have a workbook with 2 sheets, lets say w1 and w2. w1 is updated by VBA inserting rows on top of it. In w2 I have the formula: =countif(w1!$a$1:$e$9,1). After the row insertion the formula i...
Hi
I need to use a formula that will count the number of my staff listed on a worksheet based on 2 criteria. Firstly their department. Secondly where they have worked more than 4.5 hours.
...
Hello
I have a coloum of surnames and names sperated by a comma on sheet 1, i wish to have a formula on sheet 2 that grabs the a cell and splits the name and suranme in to seperate cells.
...
Hi Experts! Attached is a sample spreadsheet of a much larger spreadsheet that I need to have calculate whether the word in cell(A1) matches the other cells in that row (B1-D1). Then again o...
I am trying to load data to specific cells in a spreadsheet with a procedure running in an Access database. In order to identify the specific cell to be updated, I am trying to create a column...
Hi dave,
Could you please enter the code that could deal with multiple absentee's.
Many thanks
Keir
