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):
column K has dollar amounts.
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
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?
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...
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()
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
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
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?
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
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...
Hello everyone. I have a short question i really really need answering.
A1 = 350 euro
B1 = 500 euro C1 = B1-A1 (ok i do a simple SUM) but in case 1 variable "Say.... B5 isnt in yet so the box is blank..." How do i
B2 = 450 euro C2 = B2-A1...
I had excell 2007 and i upgrade to 2016.
everything was working fine with 2007 and also excell 365
i have this nesting and how i can change to be able to used with excell 2016
=(IF(G3="STORAGE 1",".666666666",(IF(G3="STORAGE 2",".80",(IF(G3="TRANSPORTATION",".80",(IF(G3="STORAGE...
I need some help writing a macro that will combine duplicate entries and delete out one of the entries. Please see table below: In below table I would like to combine the two entries for 123 on one row displaying all three reasons. I have a lot of data, so it would need to be a macro. Any help...
I am not quite new to VBA in a practical sense.
I have been working on this macro today but I cant seem to get it to paste for some reason, It was intended to open hyperlinked documents from a excel file, within this document is a word table, from which I run a macro to copy the...
I am wondering if there is a way to insert multiple blank rows in between my occupied cells which are individual interest rate scenarios broken down by 12 months for 30 years. In one place I need to add 348 blank rows and in other places on my worksheet I need to add 240 blank rows four times...