writing

  1. H

    Auto Click Userforms

    Hi, I'm not sure if if this can be done, but i figured I'd ask. I have code that opens another workbook and changes data, which generates a userform that you must then click OK for the code to continue running. Is there a way to "bypass" that userform, by writing code that will click the "OK"...
  2. J

    writing Now() to a cell but hiding date format ?

    Hi, when i write date/time to a cell like this: Range("G2").Value = Now it outputs like: 19/09/2018 01:32:24 which is correct but im wanting it to display time only. I need the date for various calculations so cant just use Time() function. I can manually set format to hh:mm after writing to...
  3. T

    Countifs one of the arguments is month and year???

    Hi I'm using a countifs function where there are 3 arguments. One of the arguments i'm asking it to look at is a date and if it falls in a certain month and year then it counts it as long as the other arguments also qualify, how do i go about writing this into my formula? Any and all help will...
  4. aschenbrenerm

    VBA Report Development

    Hello all - I'm looking to see if it's necessary for me to go the route of writing a macro for this project. I have about 150,000 lines of data monthly. Each line contains division, branch, manufacturer, supplier, part number, Internal number and price. There are about 20 divisions, 500...
  5. J

    VBA code to move multiple values associated with one student to specific cell

    Hello all, So I am just starting to venture into Excel VBA and I have been able to patch some things together with the help of this site, but I am now stumped as to how to resolve this one issue. I have a large report that has the workshop segments for a specific student registered that semester...
  6. D

    Macros don't work if I "Save As" with different name

    I'm sorry, I'm new to writing macros. I'm ok with recording them, but writing is different. I have some macros in a workbook, and if I save it as a different workbook, it won't find the macros when I've assigned them Quick Access Toolbar shortcuts. I must be missing some code...
  7. H

    Writing Data From One Workbook to Another Workbook via VBA

    As the title of this post suggests, I'm trying to use VBA to write some data into another workbook. I did some looking on the internet and this is what I've found. This code doesn't crash, but it sure as heck isn't writing the data to anyplace where I'm expecting it! Not sure what bearing this...
  8. R

    Issue with formula

    Hello guys, I am trying to set a formula. The formula that I need Is something: If F5 is one stuff here, G5=to the corresponding stuff in the table below. F5 is the cell with multiple choice the formula has to be insert in G5, were actually there is 160. Thank you.
  9. E

    Need help writing a MAX IF function

    I am a professed excel noob and so I need help writing this function. I need to write a function where a column of values will subtract from an original value until the value reaches zero. If my original value is 125, I need the following table to look like this <tbody> B1 20 B2 20 B3...
  10. E

    Difference in writing code in worksheets vs modules?

    What is the difference between writing your VBA code within the worksheet itself vs having it saved in a module (or class module)?
  11. P

    If statement - simpler?

    Is there a simpler way of writing this IF statement? =IF(MONTH(B3)=7,11,IF(MONTH(B3)=8,10,IF(MONTH(B3)=9,9,IF(MONTH(B3)=10,8,IF(MONTH(B3)=11,7,IF(MONTH(B3)=12,6,IF(MONTH(B3)=1,5,IF(MONTH(B3)=2,4,IF(MONTH(B3)=3,3,IF(MONTH(B3)=4,2,IF(MONTH(B3)=5,1))))))))))) Thank you!
  12. G

    Writing a formula in VBA that checks for blank cells

    Good morning, i'm writing a simple formula that substract 2 values if a cell is not blank & Excel keeps-on guiving me errors...this seems simple, but i'm not sure where the error is located? Dim FormuleDonnee As String FormuleDonnee = "=if($G21<>"";$J21-$G21;"")" Range("o21").formula =...
  13. M

    Open file with password

    Could you help me how to write VBA to open file which have password for writing. So I would like to open this file only for reading. Thank you.
  14. G

    Better/More Elegant Formula question

    Hi there, I've got a formula: SUM(A1*B1, A2*B2, A3*B3, A4*B4, etc..). Is there a more elegant (or better practice) way of writing it or is this the best approach?
  15. M

    Sumproduct Query

    I have a formula: SUMPRODUCT((PaygroupCode=B2)*(Nationality= {"Nepal","Sudan","Chinese","Japanese","African","British","American"}) *(TotalSalary)) My Query: How can I put the: {"Nepal","Sudan","Chinese","Japanese","African","British","American"} in a list and name it in the "Name Manager"...
  16. M

    Cell font color function

    Hi I'd like to create a function which returns the number 1 if the TEXT of a cell in the preceding column is red. Is it possible to do this with VBA? I was thinking of writing something along these lines, but would appreciate any pointers! Thanks in advance. Function FontDetect()...
  17. P

    help with an "If AND" formula

    I'm running into a challenge with an "if And" formula. What I want to do: If BV4 = .46, then 0 else if BV4<.46 and AT4<5 then vlookup BV4 to the Rate table else 9 Can you help me figure out what's the issue? Its returning "False" =IF(BV4=0.46,0...
  18. W

    Shorten Cell Writing

    So, I have a bunch of conditions, that based on those conditions, an inputbox writes to a different cell. Instead of writing the code over and over, I figured I would: If _______ then capCell = Sheets("SheetName").Cell(5, 5) end if If ________ then CapCell = Sheets("SheetName").Cell(5.8) etc...
  19. Z

    4096 Colors

    Excel can display 16,777,216 colors. 4,096 squared. How would I go about writing a macro that would show every 4,096th color?
  20. G

    Using Sumifs on filtered range

    I have a sheet that has sales data from 2015-2017 listed by day. What I would like to do is filter the data and then pull out data for each day within the filtered data. I don't think Sumifs will work since it looks at the entire range. I have read that subtotal would work, just not sure how...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top