voltage

Hi! I have a table that has different voltages (24, 36, 48, and 80) on the rows and different charges (Charger 1, Charger 2 and charger 3) as columns. For every voltage, there are Three corresponding Amps depending on the charger. I want the user to type in 1) The voltage (either 24, 36, 48 or...

Hi , Is there a way to remove variable text from a string in a cell, there will be variable rows of data that may or may not contain the W/MW values, and it's not case sensitive either. Can someone help with this please From this <tbody> Voltage Switch 1/16W Ceramic Wirewound Regulator...

Hi All, Someone on this forum has kindly help me with a find command for some data that is variable. The problem I have now is if the code doesn't match a string it then errors. What I need is when the string is not found to display a Msgbox with an error then back to the user form. I've...

I'm very much a novice when it comes to Marcos & VBA but after reading loads of posts on this great forum, so far have managed to achieve the basic on what I'm trying to do. Now I'm a little stuck and getting out of depth! So I have a user form with one button that allows a txt file with a...

Hello! I have been researching this question for a while and don't know if I'm misunderstanding what I've read, or if my question truly isn't being answered... so, I'm hoping to try and explain it here and would love some help!! I am using Subtotal to understand what Categories have highest $...

All of my google-fu has failed me. Everything I find says a formula in excel cannot be calculated if anything in the formula refers to itself. I know there is a way to do this. I have seen it done before. What I want to do is create a simple formula to calculate Watts = Volts x Amps I...

I have a table with 2 columns. I would like to divide all the values in column B into new row based on the char(10) end of line. Sample table - before: <tbody> Product code Description 110/1 - manual operation - high voltage - yellow color - email notification 110/2 - automatic operation...

Hello, Pls don't bash me but I have reached my limits with excel I am looking for some help with some statistical help. I have 3 data columns Date of Measure/ Time of Measure/ Voltage Measurements. I have 31 days of data with samples every 2 min. The time is shown in 24hrs format. Is that a...