base

I have tried numerous ways to get this to work and keep getting an "atrribute syntax specified to the directory service is invalid". I am new to active directory and have never used nonrational database querying before. It seems to connect fine but after that no matter what I try it will not get...

I have a formula that I'm having an issue with. Normal Formula is Base Cost+Total Misc +((Base Cost+Total Misc)*Mark-UP %)+Mark-Up Amount = Total Cost So Base Cost = 27.08 (A) Total Misc = .76 (B) Mark-Up % = 1.5% (C) Mark-UP Amount= 0 (D) 27.00 + .76 = 27.76 27.76 +(27.76*1.5%)Which is...

Hey! Just created a macro. When I run it from the workbook where I created it, it runs just fine (if I copy the base from another excel). But after exporting it as an Add-in and trying to run it with a keyboard combination it gives me the error: "That name is already taken. Try a different...

Hi For some reason, the below code don't work. It shows the error message even when all my filtered rows =base Thank you Option Explicit Sub Macro1() ' ' Macro1 Macro ' ' Dim base As Integer Dim c As Range base = InputBox("State base")...

I am using a centralized data base on an FTP server that I need to form a connection to from excel to write, update, and pull data. Thus far I can get this to work when the data base in on my local computer, but once it's on the server I can't open the connection with a macro. The following is...

I am having some consistently inconsistent results using either vlookup or index match. i am looking up interest rates in a table to find the market strike price when i open the workbook. The user will select a product from the drop down and based on the product you will get a title in Cell...

Hello everybody, Probably an easy question for everybody here. I want to add multiple cells base on another cell text. For example I want to add D7 if B8 says UTO with H7 if J8 says UTO. I dont want D7 to add up with H7 if another text is included in D8 or J8...

Hello, I would like to create a macro-enabled template that will take the TOTALS (row) from each of the below columns and move them to the bolded section below. Thanks for any assistance you can provide! G <colgroup><col><col><col><col><col><col><col><col><col><col><col><col...

I have a workbook with a number of tables for dependent lists. Below is the formula for the third dependent list and it works for the most part, but I am getting strange results. When certain values are selected in column B the problem part of the below formula will result in #N/A or the wrong...

Hello, I have a data set similar to below. Each lane ID has a base price that I am paying now. I have had suppliers return bids and I have ranked them compared to the base. Column D has the formula =countifs(a:a,a2,C:C,"<"&c2)+1 this allows the formula to be filled down column D but when the...

I Have a data in aspreadsheet that is spread horizantally see below. <colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="width:48pt" width="64"> <col...

Hi, I am trying to populate a cell with information based on certain text in the column, and using index match to insert the data in the correct line. Below is a summary of the data. It seems simple but I just can't find anything that works. Excel 2010 <colgroup><col style="width...

Using Excel 2010. I want Excel to alert me if a cell value is NOT equal Base or 2*Base, but when a call is NOT Base, it could be 2*Base, or vice versa; hence Excel always tell me it is wrong. How should I modify my below code? Thank you Sub SubTotal_test() Dim k, i, j, minim, countleft...

So I'm putting together a spreadsheet for calculating hours for a paycheck and I've run into an issue generating a running total to calculate overtime. Here's my columns: Date (One row per day worked) Week number Hours worked (this is where the data gets entered, everything else is calculated)...

A B C D E F G H I 1 Players 1 2 3 4 Total pts Sets Won Rank 2 1 john X 2 1 2 5 9 3 2 james 1 X 1 2 4 5 4 3 mathew 2 2 X 1 5 5 5 4 ace 1 1 2...

in my workbook I have a sheet for product and a sheet for receipts data base (that would be a growing data base of all items sold) I have each of my inventory items number and use that number to auto populate my receipts with description and price. I would like to search the data base for any...

how to relate a particular cell in an excel sheet with a value given at a specific location in a web data base

<tbody> A B C D E F G H I J 1 Home Team Home Score Away Score Away Team Scorer 1 Scorer 2 Team A Team B Team C 2 Team A Team B Player A1 Player B1 Player C1 3 Team C Team D Player A2 Player B2 Player C2 4 Player A3 Player B3 Player C3...

I have a table similar like below, I want to do a formula so that depends on the value of the first row (T1, T2 or T3) it will take the corresponding value and subtract the Date column then sum the total value. <tbody> ID Date T1 T2 T3 1 1/1/2017 7/1/2017 8/1/2017 9/1/2017 2 1/1/2016...

Hello All, Kindly solve my code maybe i did something wrong i want to run a macro automatically on base of cell A2 Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("$A2:$A2")) And Value = "1" Then Application.Run "Macro1" End If End Sub