Hello All,
I am working on a project that has several macros but there is one piece of the puzzle I am unable to completed. I will do my best to explain what I need visually.
I have a loop that looks at a sheet (Timing Assumptions) and based on a row called Percentages, the user is able to...
I currently have this data in a sheet
Sl No
Date
Reviewed by
Assignment
Pole Number
Feature Class
Attribute
Error Category
Observation
1
8/2/2019
Bob.B
Batch1
101039656
Cross-Arm
Rotation
Attribute
Arm is reversed, causing primaries to cross; Delete riser.
2
8/2/2019
Bob.B
Batch1...
The string can be like "abc123(456 k789)". It is to be splitted in array like array[0]=123, array[1]=456, array[2]= 789. So the problem is to split array based on numbers.
Hi Experts, Could you help me with formulas to split addresses?
I need to count the spaces from the left and split the street number into column B, then split the street name(s) into column C, then count the spaces from the right and split the the street type into column D...
Hi, need help with the following. Have a workbook with 1200 lines and 4 columns.
Its a list of building material for a office block split by size. For each size there are a number of different products listed. These are then replicated over the 49 floors of the building. Sample below ...
Hello guys,
I have a sequence:
<colgroup><col></colgroup><tbody>
00000001
00000005
00000009
00000013
00000017
00000021
</tbody>
I want to extend it indefinitely, well until it fits, but i was not sure what the best approach would be.
I was thinking of taking it as a string...
I have a split form based on Table. The below code runs an append query that updates the aforementioned table. My problem is that after the append query is run, the Split form does not refresh to show the new data that was added to the form. If I hit the Refresh button in the Ribbon the form...
We recently upgraded all our systems to Windows 10 64 bit and Microsoft Office Professional 64 bit.
We were using a split access database with Office 2013 which was working perfectly. Since the upgrade, when using the database on one of the systems, it constantly crashes and then Access...
Hello.
In column A (A1:A600) I have a dates and time in format dd.mm.yyyy - hh:mm (example. 07.10.2019 - 21:00).
Somehow I need to find an 'average' date for all those dates in column A (split data/dates in column A into two parts) and then to assign an index to each date (column A) according...
Hi,
I need a sum of time to be displayed in two colums rather than 1.
E.g. 7,4 or 7:24 needs to be one culumn with a 7 and another column with a 24.
Any suggestions?
Hi! I can't seem to find a way to split cells in Excel using formulas (I need it to be dynamic, so I can't use the built-in splitter).
What I have is up to 8 rows and 39 columns put into one cell. It's easy enough to get them spread out when I get them split up, but I can't split them. I can't...
Hi
I want to ask user to enter address for example 100 main street, and then my code will split the number and street name.
I tried the following but got error message. I am thinking of array must be use or do you think there is easier way to do that
thank you very much
Sub myfirst()
Dim...
When I run the following code, the watch window reports the following:
Watch : : CurrentRegion : <Expression not defined in context> : Empty : Splitx.TestCode
Sub TestCode()
Dim arr As Variant
Dim txtGPAddr1 As String
Dim txtGPAddr2 As String
Dim txtGPAddr3 As String
Dim...
I some data in lets say column D that has information such as:
Product 1, Product 2, Product 3
Product 4
Product 2, Product 4
Product 7
etc.
What i want to do is use a vba to turn this into one column somewhere else say sheet 2 column A
so: the data would look like
Product 1
Product 2...
Hi team,
I have a bit strange problem. Quite often one payment needs to be split to several invoices.
Most days there are no issues, however some days this split data total does not add up to original number. If there is a difference I would like to use some formula to try to find combination...
I created a UDF that calculates how many minutes it takes to complete a certain task.
(ex: =MinutesToComplete(1,0.18,10,50,20) )
Is there a way to extract each argument/parameter?
(ex: =RightParameter() ) and the answer would be 20
I have a Front_DB_A with a table called RS and another Front_DB_B with a table called RS_Hist, both are split databases and have tables linked to the Front_DB_A database. My dilemma until we can move it to SQL Server which we are waiting on is that I have a run a query that will combine both...
Hello,
I am currently using a VBA code which extracts emails from outlook. I am attempting to use the split function in order to separate the body of the email using a colon as a delimiter. I am extremely new to VBA only learning what I can from forums and Google searches and one thing I've yet...
I have been doing some research but was unable to find exactly what I am trying to achieve. I have been working with VBA frequently but am not quite advanced enough yet to do do this, so I would really appreciate some help!
I have a list of customer bookings, with various information and a date...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.