1. J

    Unique ID field based on other fields entered in a record

    Hi, Firstly, thanks for taking the time. I am extremely new to Access, so hopefully this makes some sense. I have a table with some address details and I want to generate a Unique ID (either in the ID field or a new field) which relates back to the initials entered into the "State" field...
  2. IIII

    Formula to return a cell value based on criteria

    Hi All, I have this simple assets tracker attached below. What I'm hoping to do here is to auto-populate the name from Column C (Assigned To), into Column I (Reassigned To) when the same device (by serial # in Column B) has been reassigned to a new user. I've tried using the INDEX w/MATCH...
  3. V

    How can I simplify this?

    Hi, New to vba and using it to make macros. I built a macro based off one I found online. It's designed to delete rows if they have certain criteria, but each criteria is in separate auto filter section. Is there a way to list all of the criteria(TV show names) in one "section" ? Sub...
  4. W

    Macro help

    Hi, My team pulls open orders weekly and puts them into a workbook. This workbook has all the columns/data I need but I want it in a specific format and it is also always put in the same place with generally the same name. I need to pull into separate workbooks the sum of units by the due date...
  5. D

    Referencing Cells from a Separate Work Book, but NOT Cell Position

    Hi Everyone! What I am trying to do is link start and end dates from one work book into another, but not the exact cell position where the date currently is. I can do the first part easily enough by putting "=" in the cell of my current work book, and then selecting the date cell from my...
  6. J

    Splitting an allocation between stores based on the current stock level

    Hi, I am currently trying to write a formula to be able to automate allocating stock between certain shops/stores. I have to allocate the stock based on the current stock holdings in those stores in relation to the sales that they receive. For example if one store sells 10 every week and the...
  7. C

    For each unique string, need to find matching strings using substrings without putting string automatically

    Quite a complicated question for Excel, I think, but okay... There are 10 thousand lines. For each unique string, need to find matching strings using substrings. That is: 1) yellow apple, ..., 9999) golden apple - input values. 1)Yellow apple and 9999)golden apple are output values that need to...
  8. S

    VBA code auto generate email based on cell value

    Hi, I am totally new to VBA but have been trying to piece together code to send an email to specific people based on non-numerical cell value, I have been all over the map, emails sending now they aren’t, but they were sending to everyone, not just the intended recipient, the attachment only...
  9. S

    Excel Macro Help - Borders

    Hi Everyone :) I am experiencing an issue with a macro I created to help format some raw data sheets I have to deal with at work. The macro I have made is almost perfect, except I need the macro to detect the data range of the cells in use (as this changes with each RAW data file I receive) and...
  10. D

    Macro used to send automatic emails

    I am using the Ron de Bruin macro to send automatic emails to various users and that is working perfectly. As below: Sub Send_Files() 'Working in Excel 2000-2016 'For Tips see: Dim OutApp As Object Dim OutMail As Object Dim sh...
  11. B

    Inserting Rows with formulas automatically populated from the row above

    I'm sure this is a simple fix, but I am trying to insert rows in an excel spreadsheet and I want the row I insert to automatically populate the same formula from the row above it. For example: In cell N6, I have =IF(C6="@",E6,0) In cell N7, I have =IF(C7="@",E7,0) Now if I insert an entire...
  12. G

    Auto-send email and auto back up at specific time

    Hi, I am trying to create an automated report to be sent out as an email. I need a email created and cells B6:S8 copied into a table and the email automatically sent from a PC. I already have a Macro to take a back up of the information in cells B8:S8 and paste it into the next available...
  13. S

    auto populate

    ok, i'll explain as best I can in d2:s2 I have week numbers in a3:a100 I have part numbers what I am looking to achieve is if I populate (as an example) h15 a formula in c15 will populate with the relevant week number from row 2
  14. A

    Auto Resize to fit different monitor sizes

    Hi - Could someone please give me bit of assistance, I am trying to get an excel document to auto resize to different monitor/screen sizes so bosses do not have to scroll around document. I have tried the code below but does not work (also not sure if putting in the right place, fairly new to...
  15. S

    Auto column width adjustment

    Hi, Due to the fixed column width the figure more than width is showing ###### and need to double click to see the figures, how column adjust itself automatically ? <colgroup><col></colgroup><tbody> </tbody>
  16. C

    Comment or Note: Auto Fill with date & time

    WITHOUT doing a VBA is there a way that a note/comment can auto fill the date and time as well as the person's name? Thank you :)
  17. D

    auto track CTO if an employee came in during a Holiday

    Hi All, Noob Here :) seeking help in auto tracking of employee's earned Compulsory Time off based on an employee's schedule.
  18. P

    Is there a way to reverse the weekday function

    I have a range (b2:f2) that displays the weekdays of the week(Monday-Friday). In range(b1:f1) I have the dates corresponding with those weekdays of the week. Where I am located the current date is Saturday, the 5th day of October. Which is still considered the current week. So if I were to open...
  19. H

    Column AutoFit Sometimes Set Columns to 255 Width

    Hi, This my first post, apologies if I break any rules in the forum. I am trying to use VBA to write a simple code to auto fit column width. I have data in columns A:Z and I have also merged cells D5:J5. Naturally, I think a simple line like the following will do the job...
  20. S

    IF with two conditions

    Hi I need formula with if command in column E based on data from A to D, Secondary no Discount <tbody> Segment Transmission Value Discount % Result Primary AUTO 1000 20% 200 Primary<strike></strike> MANUAL 1000 10% 100 Secondary AUTO 1000 0% 0 Secondary<strike></strike> MANUAL...

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