base

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

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?

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

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

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

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

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

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!

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

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

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

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

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

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

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!

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

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

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

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?

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