Microsoft Excel Forum

Date Detail Summary Ref 1 Ref 2 Ref 3 Ref 4 Ref 5 24-Nov RMC XX Other Sue B Martin Khanyiso Sue L 25-Nov RMC Sue B XX Other Martin Conrad Charles 25-Nov OVA Sue B 26-Nov OVA 29-Nov STMARY Catholic Cup Dianne Conrad 1-Dec NDSS Sr Girls Amanda Dale Ted Debbie Hi everyone,

Recently I have problems with some Excel-files, when I Move (Cut and paste) data. It does not matter if it is large data or just 1 word... The files are not complicated: no macro's, external connections. But still I have to wait almost 1 minute before my computer has "finished the job". Please inform me if I am not the only one with this...

Private Sub Button1_Click() strSQL = "Select Distinct From Order by " closeRS OpenDB cmbcountry.Clear rs.Open strSQL, cnn, adOpenKeyset, adLockOptimistic If rs.RecordCount > 0 Then Do While Not rs.EOF cmbcountry.AddItem rs.Fields(0)

I have a data entry form for generating bar codes that asks for a Sample ID for cell A1 and the number of samples to be labeled in C1. I am having trouble writing a VBA script that will autofill the column from A2 down to Ax where x = number of samples entered into C1. The bar codes are generated in the adjacent B column. Any help would...

I observed some XL sheets that the data which is fed into the sheets are cannot be edited and even all the options of menus and tools of toolbars are deactivated. only I can able to feed and save the data. How this is can b made ? And how to insert controls like checkbox, dropdown list, radio buttons in XL cells of sheets. plz guide.

Does it possible if any excel cell value changed send IM to gtalk user automatically who listed on. I have been using seet email but email has sending limit so i want to change that . anyone help I really appreciate.

Hi, Using excel macro I am creating powerpoint presentation and adding graphs on slides. Similar to, Application.Visible=False and Application.ScreenUpdating=False is there any way to make the powepoint and the screen updating false. The reason I want this is to prevent the user from clicking the powerpoint slide while macro is running.

.Subject = "ECR needs your attention for:" I need to make it to where if seeks out a specific employee that it pertains to. Can somebody help me please?

Hi, Please check attached excel workbook. The first sheet is the "RawData" the data in this sheet needs to be plotted into "PlotData" sheet according to the time Column E(Time). and Name (Column A) In PlotData Sheet the frequency is given i.e. 30 min and 60 min. For e.g. we will 1st check the Names in Name column of RawData sheet with the...

see i have 2 sheets and in one sheet i'm using 6 combo box,1 command box . now i want to use that command button to create the database filled in combo box in sheet2...also want to know how to add datepicker

I am preparing a to do list in which there is Status (completed / not yet) and Task name in sheet 1. In sheet 2 (completed) the task which is marked completed is moved with the current time. Now I need to work out on adding two more columns D (person) and E (estimated completion date) in Sheet 1. So, When I mark the task as Completed & click on...

I need to cacluate the difference between a start date/time and an end date/time. The time is in millitary time but I need the end result to be in hh:mm.

I have a public json URL that outputs a digit. How can i have a certain excel spreadsheet cell pull the data from that URL and use that data?

Hi, I have an Excel/VBA UserForm that accepts the date that a record is created (manual entry ito a textbox or via click of a command button which fills the textbox with the system date from the Date() function.) I've used a temporary mgsbox, formatting the output to confirm that the correct date is being set: Me!DateBookingMade =...

Hi, I want to export the excel file uploaded to sharepoint site using the Excel VBA macro. Could you please help me with this. I tried WebQuery option but no success.

Hey everyone, I’m hoping someone can help. I’m trying to set up a data import from a table in one workbook to one laid out exactly the same in another. However when I try to set up the link for the first time it’s inserting new cells rather than populating the existing table. I know once the data is in I can choose to format data import and choose...

I have written below code to generate a Graph based on a data in a sheet. But getting below errors. 1. The specified dimension is not valid for the current chart type. 2. Method 'MarkerStyle' of object 'Series' Failed 3. Method 'Delete' of object 'Series' Failed 4. Application Defined or object Defined Error Below code creates total 36...

Hi I would like to ask the correct formula in Excel. I would like to sum up the total number of hours per staff and then how many hours and minutes left or excess within 8 hours. Here's my table: Staff Name Job No. Job No. Job No. Job No. Total Working Hours Remaining/ Over Time spent to Eight hours Time Start Time End Time...

Hi I'm getting the worksheet error #NAME? when my formula in VBA gets evaluated. Cells(x + y + 4, "D").Formula = "=sum(cells(x+1 , 4) : cells(x+y+1 , 4))" I know that the error is refering to the word cells in the formula, but I don't know how to make Excel accept a formula that is not in the usual ColRow : ColRow format.

I have a simple Excel worksheet that updates with data by columns. I did the record macro, creating code for drawing the 1st graph based on Columns A,B&C. Then I need do loop on columns from C to EY. To draw the 2nd graph based on Columns A,B&D; 3rd graph based on columns A,B&E ;4th graph based on columns A,B&F ... till the graph based on columns...

I have an Excel workbook with eight data connections to various SQL Server data sources, most of them stored procedures that return tables of data. The connections are set to refresh either when the workbook is opened or automatically when the contents of the cells that contain the SP parameters change. Right now, if someone lacks the security...

I have to formulate this in excel and was wondering if anyone could help me with the formulas. It has also determined that the number of repair claims filed each week is a random variable which can take values 1, 2, 4, 5, 6, 7, 8, 9. The probability of having 1 or 9 claims in a week is equal. The probability that there are 2, 6, 7 or 8 claims...

please i need help i have add in data analysis plus in my excel, but when i want to run the for exemple the t-mean or Z-mean i receive this error "the event source ExceptionManagerInternalException does not exist and cannot be created with the current permission"

I need basic Getval function, I had it and it worked but something happened and it's not working. I need to search specific string in given excel into new excel and copy values of it's adjscent column. Pls help - i believe simple GetVal() function would work but I don't have it's VBA code. Pls help with code

Hello everybody I have four cells which I need to navigate through using Enter key My range is ("D10:D13") If I was in D10 and press Enter then go to D11 (That's the deafult)>>>> If I was in D13 and Press Enter key I need to go to D10 again As for other cells no change in using Enter key Hope it is clear