easy

  1. T

    Excel VBA - search box for any value but to stay in row/ column

    Hello Mr. Excel Community Since 5 hours I am struggling with the following code, which I'd love to expand. I simply want to mimic the built in ctrl + F search tool via an Input Box, adding the feature to stay in row/column (ActiveCell) while looking for the name (letters not numbers). Sub...
  2. I

    Probably easy but im unsure how to word

    Hello, like i said probably an easy thing to do but im not able to search properly for what I want to do, basically I would like to take a current total, and add to it when another cell total changes, except i already am seeing errors in what i want to do. So i think i want a macro so after all...
  3. D

    Loop through an Array, change values

    Hi there! I want to loop through an array looking for the below values. IF it finds them, I want to change the value, if it doesn't, just move on. <colgroup><col></colgroup><tbody> 10 Very Easy 10 Demonstrated Well 10 Very Satisfied 1 Not Demonstrated 1 Not Satisfied 1 Not Easy...
  4. L

    Calculate Age

    Hi I am trying to find the best and easiest way to calculate age. I thought it is something easy but it turn it is a bit complex. The websites below showing how to calculate age. But I only found Excel-Easy.com is better and easier yet it is not that easy because they use a function called...
  5. G

    Excel VBA - Easy Question

    This should be a really easy question for you VBA experts. I have the following code: Range(Selection, Selection.End(xlUp)).Select What I would like to do is have one line code that does the above but then keep the selection but one cell below the full range. For example, if the code above...
  6. J

    Removing everything outside brackets in a cell

    Hi!! I have a bunch of cells which contain data similar to "0.120 (3.048)". I want to delete everything out side the brackets. Is there an easy way to do this? Thanks in advance
  7. G

    Simple formula help...

    I am not sure if it because it is Monday, but I am having trouble with a formula that I thought would be pretty easy. Here is a simplified version of what I am trying to accomplish: I have two columns (A1:B5) and a special cell A10 (ifgreater than 0). Column A is filled in manually with %...
  8. P

    Help with Nested IF function

    I'm hoping someone can help me. I have a 100 inputs and 100 outputs I populate column A with inputs and column B with outputs. Column C will contain data that will match to one cell in column A I want Column D to populate with the corresponding output from Column B. Is there an easy way to...
  9. S

    Export Data from website using javascript

    Hi there, I am trying to export data from a website example: https://www.flashscore.com/baseball/usa/mlb/ When I do, the data pasted from excel is shown vertically and not horizontally as on the website. Is there an easy alternative to get this data from the website to excel in a similar...
  10. S

    code to printout 2 copies not 1

    Hello, I use this line in my code to printout copies of sheet3, I need it to print 2 copies, not just 1? any help would be greatly appreciated. I am sure it is very easy change to this line, but I cant get it to work. Sheet3.Range("A1:I20").PrintOut Next Next End With
  11. S

    Deleting blank cells

    Hi there, Maybe this is an easy task for you guys, but I've been struggling with it. Basically, I need to converter the table 1 into the table 2. Thank you for any help! <colgroup><col style="mso-width-source:userset;mso-width-alt:3868;width:82pt" width="109"> <col style="width:48pt"...
  12. A

    Highest simultaneous occurence at a time

    Dear all, I would need a formula which gives the highest simultaneous occurence. In this simplyfied example it would 2 for "A" and 1 for "B" Seems easy but I don't grasp it. Thanks very much ... Arjen <colgroup><col width="64" style="width: 48pt;"> <col width="72" style="width: 54pt...
  13. Z

    Quick "if not found" code request

    Here's an easy one (for those of you who are not ME, that is)... I have a multi-tab workbook that includes a MASTER sheet as well as (usually) a sheet named "UNKNOWN". My code copies some data from MASTER to UNKNOWN...BUT...what happens if "UNKNOWN" isn't there? I'm sure it will crash because...
  14. K

    Updating Inventory Based on Daily Pull Values

    Okay excel genius', I'm stuck in a rut and need your help! I work at a shop that carries a stock of liquids. It is my job to keep track of the inventory on a daily basis. If this was my only job, then it would be easy, but its not. So, I began working on an Excel file that could automate the...
  15. S

    Sum that returns a statement

    Hi All, I'm calculating the number of days between 2 dates which is really easy, however some of the cells don't have dates in them and I'd like it to return something other than value, maybe "N/A" so we know it's been seen to. Currently it's just "AS2-AC2" Is there an easy way to do the...
  16. R

    RPI Tool

    Was wondering if anyone could help me out with an Rating Percentage Index (RPI) tool. There used to be one at https://techgraphs.fangraphs.com/an-rpi-spreadsheet-for-you-yes-you/ but it seems it has been taken down. I am trying to calculate RPI for a sports project I am working on and the WP...
  17. M

    roundup before multiplied formula??

    I'm sure this is easy for somebody.. How do I multiply two numbers rounded up to the next whole number... =(A1*B1) Cell values: 20.5 x 30.25 = 620.125 ...not like this<not like="" this<not="" this="" (="A1*B1)=" 620.125 but lke this... 20.5 x 30.25 (21 x 31) = 651 651 is the answer I'm...
  18. P

    So simple but it just doesn't work!

    I'm new to Macros and working with a training tutorial, and there's a really simple problem, I just cannot figure out. I feel so stupid asking but i need help. Here's my code. So... I copied and pasted the line currently ' - which works fine But when I type the line, I get an "Unable to get...
  19. gheyman

    Access: Delete all the records in a Table

    Is there an easy way to delete all the records in a table? I don't want to delete the table, just the records. Thanks
  20. M

    Count if across tabs

    I have a workbook with 52 tabs all identical in layout Example I am trying to create a formula that will look at cell D2 in each tab (except the one i am in) and count if the cell = 'x' is it is easy to do this or do I need to create a megaformula

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    • Started by AndyEd
    • Replies: 29
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    • Started by omairhe
    • Replies: 26
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    • Started by Marwan69
    • Replies: 24
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    • Started by Burrgogi
    • Replies: 22
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top