excell

Hello, my question is how to seperate a sentence that includes many commas for example item1,item2,item3 what i want to do is they should look like item1 but in the same cell like in A1 item2...

I know I can insert date and time using ctrl+; followed by a space followed by ctrl+shift+; But I am looking for a single shortcut that can insert date and time simultaneously. Exactly like we do in Google Sheet. In Google sheet cells we insert date and time using ctrl+shift+alt+; Anyone know...

We have 2 sheets (Sheet 1) and (Sheet 2). sheets1 has 3 columns (Title1) - (Size1) - (Stock1). sheets2 has 3 columns (Title2) - (Size2) - (Stock2). We want to update each cell in (Stock2) Column in (Sheet 2) when any cell in Title1 and size1 in sheet1 = any cell in Title2 and And Size2...

Hi, looking for a bit of advice. i have a built spreadsheet where i am calculating the cost of a product based on other factors. To give an example: A1) 2.21 >>>>entered manually A2)=A1 >>>> (so shows 2.21) A3)=ROUND(SUM(35/B11),2) >>>> to explain, this is taking a figure of 35, then...

I've managed to compare 3 separate ranges on one workbook with 3 single ranges across 3 workbooks. Right now it's written to just pop up with a message box either letting me know the data is the same or the data is different. What I would like to do is for the macro to not only let me know there...

Hope you guys can help, I have an excel file with multiple tabs and power point presentation template. One of the tabs on excel file has following information: column B is Product column and has following products (each product has multiple lines): AINJ CRIV HCRV column K has dollar amounts. I...

HI , Looking for ISBN (10 and 13) validation specifically for ISBN 13 so I can used on VBA Macros , I saw some ISBN 10 validation , but couldn't find proper one for ISBN 13 , the function I can used in VBA like the following : if fn_isValidISBN13('1234567890123') then 'do something end if...

Hi all, Every day I export 4 workbooks from Navision. I would like to create a macro that will put all 4 workbooks into one and then do some calculations. The problem is that these workbooks have different names every day. Is there a way to activate the next workbook regardless of the name?

Good day, I am new to the VBA code for excell. I am trying to automate a process for my small business. I am trying to create a macro to find multiple values, one of them is "B00ZL31582". All i came with so far is: Cells.Find(What:="B00ZL31582", After:=ActiveCell, LookIn:=xlValues, _...

I have a system which generates alerts for part usage but I worry its spamming them. Part lifespan = 30,000 (approx 1 month), Device “A” Average is 1% part lifespan per month or 300 counts per month Device “B” Average is 100% so 30K per month So how do I math? To get a dynamic usage figure...

Please can anyone explain the following message I am getting each time I open Excell ... 5F921200 file format is not valid Thanks

Dera Sir, I want to get all the name of files contain in certain folder in Excel by using VBA Code. I want to update all the files name in certain column in certain sheet. Can It possibe in excell. Thank You in advance.

hi heres my code but its keeping the sheet 1 text format when i want it to be like sheet 2 text and cell format Private Sub CommandButton1_Click() Sheets("sheet1").Range("A1:A4").SpecialCells(xlConstants).copy _ Sheets("sheet2").Range("A1:A4").End(xlUp) End Sub

1 Copy only the text of a range (A1:A20) on sheet 1 2 paste that text on the next empty row on sheet 2 I would give my code buts its all rubbish because as far as i got was to copy the whole range and paste it on sheet 2 with spaces

Hi Im trying to get a code that can take data from multiple cells from sheet1 and place them in the same cell on sheet2 but the tricky part is keeping the same colors of the text from sheet1. For example sheet one A1-Roses A2-Are Read should read on sheet2 A1-RosesAre Red

Dear Mr. Jury, Please help me for storing all worksheets from Workbooks into One Excell Book. Thanks and Regards, DINAUKAUR

Hi, i have a column which is formatted to populate an overdue when a date is less then today. When I drag the formate down it populates overdue as there is no date currently. How to i I keep the formate however when the source cell is blank the formatted blank remains blank too? sam

Friends, How can I call a stored procedure from Vba Excell for Mac? Thanks

i have data that is imported into excell. the data is expressed like this"1h, 24m" which indicates 1 hour 24 minutes how can i convert that into total mins excell doesnt recognise "1h, 24m" as a measure of time is there any vba formula i could use to convert it into total mins? thanks for any help

Hello I am trying to find a way to assign 6 different values to a cell based on numbers that were entered in another cell. So for example: in Cell D2 someone would enter either 1, 2,3,4,5 or 6. I then want Cell H2 to automatically put a 10 if there was a 1 in D2, a 6 if there was a 2 in D2...