excell

  1. G

    Find Multiple Command For VBA in Excell

    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, _...
  2. G

    % Math for usage Excell

    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...
  3. A

    5F921200 file format is not valid

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

    Getting List of file in certain folder

    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.
  5. Z

    Paste but keep Destination formatting

    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
  6. Z

    If and Else Copy & Paste

    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
  7. Z

    Ampersand from another sheet and keeping two different text colors VBA

    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
  8. D

    Storing work sheets from other Workbook into One Excel work book

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

    Help formatting an overdue column however want blank if source cell is blank

    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
  10. J

    Sql Store Procedure from Excel for Mac

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

    converting expression into total mins

    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
  12. C

    Assigning 6 values to another Cell

    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...
  13. D

    Quick Question

    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...
  14. C

    more level of nesting

    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...
  15. T

    Help merging like rows into one row

    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...
  16. E

    VBA Macro not working I dont know why

    Hi all, 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...
  17. K

    Kutools/macro for adding blank rows

    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...
  18. B

    Any one from data analysis in Germany from healthcare management

    Hi I need some information how to do pzn and atc in excell sheet please can anyone help me
  19. Q

    VBA: Fully description of object

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...
  20. B

    Resetting value in a cell to zero if another cell in the same row is selected and changed by the user

    I have a sheet where I want to calculate a price in a range of cells (i18:i26) when a percentage value is entered in range (b18:b26). If the user then wishes to input a price in range (i18:i26) I want the value of the cell in column b of the same row to change to zero. The code below...

Some videos you may like

This Week's Hot Topics

Top