Hello
1. I have a mutiople files in a network folder.
I required the folowing steps to work for ALL files in aspecified folder. This save me doing the below step to 100s of files manually.
1. To change the format of each file from .htm to .xlsx.
2. To remove the delete all rows above the table...
I do not understnad. I need to manually go to the cell and go the end of each sentnce and press delete to change the sentence to a nice format.
I need help for that please.
Maybe space space is not the correct word - but need help to prevent me doing manaually.
Please refer to sample attached exel - bad formatting F6 - Fixed G6
I would like a macro to fix - so I can run on hudreds of cells, and save me ma naually fixing.
All the macro so far do not fix my issue.
thanks
Hi
I need a macro that will remove unwanted spaces for there is a space of 1 between each word.
Bad
"3.1.13
In addition to obtaining customer approval, application service requests for configuration changes submitted by Managed Service Providers (MSP) are
approved by a Customer Adoption Team...
it does not - sorry
it gives 25 always even if cells are blank
any help will be much appreciated so it only takes those cells that are populated and not blank
hi
hi
I want the below to combine data from columns A to L -
how do I hammend the below to do so?
thanks
-
>>> use code - tags <<<
Sub k()
Dim oneColumnHead As Range
Dim columnHeads As Range
With ThisWorkbook.Sheets("shee")
Set columnHeads = Range(.Cells(2, 8), .Cells(1...
Hi
I have a table that show testing pass / fail and the dates - there are many rows.
Each rows is assigned a number (test scenario) and a test scenario may appear more that once
test scenario date completion
1 01/01/2022
1 01/01/2022
1 15/01/2022
2 01/03/2022
2 24/04/2022...
Hi
I have
=IF(L3=$T$21,$T$20,COUNTIF(Testing_Main!$K$10:$K$147,L3))
I need to add another AND ---- so that it should only add a number in the cell if this is also a number the M column of the row that is beng checked.
If there M cell is blank in the row, then it shoud return an empty...
Hi
I cant' find this solution anywhere on google.
I have a colum where a user select a value from a list.
I want the excel to prevent the user from sleecting the same choice twice .
tab: Testing_Main - cell: m10, m11,, etc. currently the user could select TEST_1 twice... i need to...
Hi
In the excle. - tab:Testing_Main CELL E8 - there is text that updated automatically.
I am not sure if this is possble.
If the text states: "CONGRATULATIONS!!!!! - ALL CELLS ARE UPDATED" - can the text be green and if the text has any other text - it should be red.
if stateemnt cell...
Hi
Please help me.
I tried to google this but I got errors messages I do not understand. I managed with the help of your experts I manged to tcolour cells red - using the conditional formating.
I need to count these cells. red now.
Range is B10 to P100
AND
R10 to R100
The tab is...