Hello does anyone know a formula to extract just the email addresses from files with records as follows:
I have a total of 25,000 records for this extraction so a truncation solution would be appreciated!
Got a new customers pc here. she had a virus last week (one of the ucash ones) . she then ""spent all day trying to fix it following instructions on various forums""
She has no idea what she actually did. the virus isnt there anymore, but now nearly nothing works on the pc. sys restore doesnt work and every single document is giving me the error ""the open office xml file xxxx.docx cannot be opened because there are problems with its contents"" details: ""the file is corrupt and cannot be opened"". this also happens with xls, xlsx, docx, doc, csv
This is kind of hard to explain.
I am creating a numerical solver that gets input from students in the form of an equation. An example being x^2 + y^2. I'd like to take this input and somehow put it into VBA as is.
This equation is going to be in a for each loop, where the values of x and y are changing with each iteration.
For i = 1 To n
m = x^2 + y^2 'Equation input from students
y1 = y + m * dx
y = y1
x = x + dx
I have a macro file, where as per my selection (Customer Name Selection), I;m able to send email to the specified customer. Like - Once I select Xerox Co. from the filter and click on Send E-mail button, all the fields of Xerox Co gets copied to new workbook and I'm able to send email to the recipient mentioned in the VBA code.
Now what I want is - instead of having the email id mentioned in the vba codes. I'll like to have a column of email id of all the customer in column B for each customer name (firstname.lastname@example.org, email@example.com).
Thanks for your help in advance
I have excel sheet that have more than 100 column. I want to make easy interface for user, my requirement is below.
detail of sheet are like
1- Column A to H are fixed and I want to filter the remaining column like I to Z.
2- When I filter the column I want the result that it will show only column that I filter and starting column A to H.
3- user interface is like drop down search of column I to Z.
I need help creating a macro that will remove a stock item from one tab and reset to zero so the macro can be run multiple times. The crux I am facing is being able to use this as a counter but in a negative sense. On the 'PRODUCTION'tab, I need to have the capability of removing stock item "TANK SIDE" from 'DS TANK' tab when a serial number is entered on the 'PRODUCTION' tab. The 'DS TANK' and 'PS TANK' tabs our inventory tabs and need the ability to add and subtract parts as they are produced and taken for assembly. I have attached a file for your perusal.
I have multiple excell worksheets with list of columns. Column C is Birth Year,column D is date of Approved, I want in Column C to calculate based on this criteria:
If Column C is <35 years add 5 years to Column D
If Column C is 35-45 years add 2 years to Column D
If Column C is >45 years add 1 years to Column D.
Please See my attached file!!
I used IF funciton but the outcome is not what i want
Sub EE_PivotRemoveTotals(Optional pt As PivotTable) 'http://excelexperts.com/xla-routines-eePivotRemoveTotals for updates on this routine If pt Is Nothing Then If ActiveSheet.PivotTables.Count = 0 Then Exit Sub Set pt = ActiveSheet.PivotTables(1) End If pt.RowGrand = False pt.ColumnGrand = False End Sub
I would need a help to copy an excel range as editable table in a powerpoint. When i tried, It was pasted as a picture or as a excel linked table which were annoying.
and i would need to paste it as an editable one (similar to a powerpoint table). please post your reply soon.
Live VBA Developer Jobs in the UK
Live Excel Developer Jobs in the UK
Excel VBA Jobs in the UK
Live Excel Jobs in Cardiff
Live Excel Jobs in Dundee
Live Excel Jobs in Perth
Live Excel Jobs in Inverness
Live Excel Jobs in Aberdeen
Live Excel Jobs in Edinburgh
Live Excel Jobs in Glasgow
Live Excel Jobs in Belfast