base

  1. Phil Smith

    Use VBA to find which row on another worksheet contains a given value

    Hello Excel People! In column A on one worksheet, "Base Roster", I have a column of numbers, in order from 1 to 70. In Column A on another worksheet, "My Roster", I also have a column of numbers, but they are not in ascending order. As my code loops through and fills in worksheet "Base...
  2. H

    VBA apply conditional formatting to another cell base on

    The conditional formatting is base on Col F to change colour. But due to Col B is not in a range so i cant use conditional formatting. Possible to use VBA apply conditional formatting base on Col F to Col B, without change any Col B data?
  3. I

    Remove strings or special characters from data

    I have over 5000 items each item has a description, my description(s) look something like this, not all consistant, but very similiar: <tbody> < p >Feed Your Crops the Extra Calcium, Magnesium,< br / >and Iron They Need If You Use a Non-Advanced Base Nutrient< br / >< br / >Plants & ndash...
  4. T

    Index/Match with OR Function

    I need one of my match criteria to be an or statement. I am currently using the below =INDEX($I$37:$I$1128,MATCH(1,INDEX((D37=$D$37:$D$1128)*(F37=$F$37:$F$1128)*($G$37:$G$1128="Base"),0,1),0)) I want the last set to look for "Base" or "Allowance"...
  5. E

    Macro to create template

    Hi, Can someone please help me with this: I have a database with the fallowing information for 200 employees: Employee Name, ID, Department, Position title, Performance rating, Base salary, Performance rating,%increase, Previous year salary . I need to create a tab for each employee with...
  6. D

    look for values base on =Today()

    <tbody> A B C D E F G H I J K L M N 1 item1 Aug. Sep. Oct. Nov. Dec. 2 item2 item1 100 200 300 1 2 3 item3 item2 50 20 40 4 7 4 item3 85 58 5 6 7 </tbody> Dear Pros, I would like cell "B1" for "item1"...
  7. P

    Sum same cell in worksheets, but number of worksheets will vary

    Hi, Long time user, but new to posting. My workbook is used to perform scenario modelling, and contains a number of worksheets, named 'Base', 'Adj1', Adj2', 'Adj3'........'Total', where Total is the sum of all preceding worksheets. However, to complicate matters, I want the ability to...
  8. O

    Differing drop down choices

    I have done some research and I have not been able to track down any information on the following. Can anyone offer any advise/direction? I want to provide a cell with drop down options that are base on the information entered in another cell. Is this possible in excel 2016 ? Thanks in advance!
  9. L

    Data Validation

    Hi I have a financial model which includes a whole heap of scenario analysis. To change the scenario for each cell you click the drop down and select best, base or worst. However, if you wan to run a worst case for everything you have to select each individual cell and select worst. Is there a...
  10. M

    Expression builder syntax, if not null then...

    Hello and thank you in advance if you can help, I have a column I created that works great: IIf([eBird_ALL_DATA Query2 Base Data Output.DAY-MONTH_VALUE]<[eBird_ALL_DATA Query2 Base Data Output.START_Date_VALUE] OR [eBird_ALL_DATA Query2 Base Data Output.DAY-MONTH_VALUE]>[eBird_ALL_DATA Query2...
  11. M

    Access Query expression builder error, please help.

    Hello and thank you in advance for helping if you can, I have an expression for building a calculated column in an Access query that has worked fine in the past, but I am trying to do it know, and because there is a query linked to this query with the same field, it is giving me "The specified...
  12. M

    Filtered Query not staying filtered when brought into another query?

    Hello and thank you in advance if you can help, I am using Excel 2019 on a PC. I am still quite new to Access, so I would appreciate any guidance to resolve this issue I am having, and I will apologize in advance if any of my explanation is confusing. I have a database that is 1,115,1867...
  13. A

    Search Code From Data Base

    Hi, I am as new in VBA to Know about a set of code where i can get a Specific information from my data base. E.g If i enter a some of data to used a form and if i missed something or wish to amend some of incorrect data to correct in data base. How can i do this. I am using below code but not...
  14. L

    Cost calculation below and above together

    I have a set of data and i have done vlookup what i need is to calculate cost on two different base levels https://imgur.com/IvskNuw heres a link to the image. now i when i enter data that is in the lvl column in the second table and the third table i have set for vlookup to get the data...
  15. J

    Excel and Access

    Is there any program or how do you do make changes to Access from Excel? I need to use Excel (its what my company loves) but make the changes I make in the spreadsheet back to Access (so I can manipulate it easier). The spreadsheet uses the same headings as in my Access data base. Thanks!
  16. D

    Conditional Calculations Based On Drop Downs

    To preface I am trying to decide if formulas, a pivot table, or VB code is the way to tackle my issue. My head is spinning. I am attempting to calculate earnings based on multiple work based scenarios. I have created drop down validations across multiple columns. Each drop down affects a per...
  17. K

    Macro to extract unique instance of multiple values in a column

    Hello All, I found this old Mr. Excel post while doing a search: https://www.mrexcel.com/forum/excel-questions/986844-vba-extract-unique-values-multiple-columns-one-column.html I have modified the code for my purposes to this: Sub ThreeColDupes() Dim MyDict As Object, MyCols As Variant...
  18. A

    Hide\UnHide columns - automatically base on cell value

    Hi guys, i've been looking, in forum, for some related request and i've not found anything that fulfill my intentions. If i am mistaken, please accept my apologies :( what i'm trying to do is something like this. Have a 30, consecutive, columns with date and i'm trying to figure it out a...
  19. K

    Formula is not working in VBA

    I remind the double quotes this time on this formula: Range("A2").Formula = "= IF(A2=0, ""Base Bid"", ""Alternate - "" & A2)" The code will not function as it is. Can anyone clue me in on what I need to change?
  20. A

    VBA to jump the Sheet on base of cell value

    Hi Excel VBA Experts, I have created a VBA to jump the Sheet on base of cell value. But it does not work, can someone help me? I have a Menu Sheet where a value has stores in B1 cell (Between 1 and 8) If I click a Text Box link to this Macro, on the base of this value, need to go that Sheet. Sub...

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