Array In Data Base

Apr 21, 2006

i have used the database from j & r solutions. i have altered it slightly to suit me. the database works fine apart from when using the find all button it will only return 4 entries. if there are more than 4 entries it returns runtime error 9.i have zipped up the code and marked where the error is shown when i debug

View 2 Replies


ADVERTISEMENT

Transferring Data From A Row Base On Value Given From One Sheet To Another?

Jul 17, 2013

We have database (attached here). I want to copy the name of candidates base on their Status to their designated tab. example Diana Longoria name will be copy to "Waiting" Tab and if I change the status to "Rejected" it will be copied to "Rejected" tab and remove name from "Waiting" tab.

View 12 Replies View Related

Use Access Data Base For Project?

Jan 12, 2009

I am working on a spreasheet that will automatically calculate the interest rate, loan to value advance, and other parameters from user inputs.

I have found a way to get the calculations to work correctly, but I have about 50 lenders to input - all with different rates and lending guidlines with respect to loan to value advances.

I am sure that I am going about it the hard way and I have no problem going at this to get it right.

I have attached the spreasheet I've started. I've only got one lender completed thus far. So if you need help sleeping at night, go ahead and see what I've done (yes it's boring).

Edit note: I don't know if using Access would make this an easier project to tackle but it is an option (I'll just have to learn
Access if that's the case - I've never used it).

View 3 Replies View Related

Copy Data From Sheet To Another One Base On Conditional?

Aug 20, 2012

I have 1 workbook with 2 sheets: sheet1 and sheet2.

Sheet 1 format:

A
B
C
D

[Code].....

My sheet2 has 5000 rows and need to copy to sheet1.

View 9 Replies View Related

Number A Colum For Sorting As Data Base

Jun 11, 2008

totaly new to Excel (just using two weeks) as a database

I need to number a colum, 1 to what ever, so that I can use that colum to re-sort the data base back into original order.

View 9 Replies View Related

Data Base UserForm - Clear ListBox

May 9, 2006

I have the existing code below. What I would like to do is clear the ListBox of all previous records found prior to the next Find All event occurring. For Example I search for "M" and it finds 3 records and these are listed in the ListBox for the user to select from, then if the user searches for "Grealy" it finds 1 record and puts it in the list but the 2nd and 3rd record from the previous Find All event still remain.

I tried using the following code

Me.ListBox1.Clear

which clears the listbox but then as soon as you hit Find All following the above mention sequence you get the result as outlined.

Private Sub cmdFind_Click()
Sheet1.Select
Dim strFind, FirstAddress As String 'what to find
Dim rSearch As Range 'range to search
Set rSearch = Sheet1.Range("b2", Range("b65536").End(xlUp))
strFind = Me.TxtEmpName.Value 'what to look for
Dim f As Integer

View 4 Replies View Related

Macro/function To Take Data From Source File Into Base File

Jun 24, 2006

I have a base excel file for summarizing some data, the problem is that the data comes from a different excel spreadsheet. What I want to do is make a function that pulls the data from another spreadsheet into my base file. It would be easy if it were just one excel sheet, but this job would require where the data is pulled from a data file which has many modified versions.

Can anyone tell me how to do this? The files with the data will be structured the exact same but with different data entered in. I just want a button so I can click the file I want the data from and have it show up on my summarizing base file.

View 9 Replies View Related

Looking Up Row Array Data In Column Array

Jul 11, 2007

On one sheet (KPI) I have either the values "x" or "" in the range A84:A89 to mark wheter to use the corresponding project in the range B84:B89. On the sheet X-ref I have the same project names in range T4:Y4 and a corresponding target value in T8:Y8

What I want is the sum (or average) of the marked-projects target-values. The result should end up in KPI!G31.
In other words I want

=sumif(A84:A89;"x";'X-ref'!T4:Y4)

but it doesn't work since the first range is an column-array and the second range is an row-array.

View 5 Replies View Related

Addition In Base 6

Jun 14, 2009

I've got a column of numbers that represent the number of overs bowled in games of cricket. Whilst these are whole numbers (eg. 34 overs + 34 overs) the addition isn't a problem, but when they are incomplete overs (eg. 34.4 overs + 34.5 overs) then the addition if out of kilter as it sums them in base 10, and not in base 6. (As there are six balls in an over, not ten for anyone who doesn't know!)

View 2 Replies View Related

How To Sum Column Base On Few Criteria

Feb 17, 2014

I would like to sum the amount column of unique date that is in active status of each account.

Account Date Status Amount
11 jan 1 A 200
12 jan 1 A 5
13 jan 1 A 1000
11 jan 1 A 200
11 jan 3 A 100
12 jan 3 A 8
13 jan 4 A 1
13 jan 4 A 1
11 jan 6 I 50
12 jan 6 A 10

Below is the expected result
Account Amount
11 300 (200+100) [200 is only add once since jan 1 of 11 has appeared more than one time]
12 23 (5+8+10)
13 1001(1000+1)

View 5 Replies View Related

Hyperlink Base Does Not Work

Mar 7, 2012

I have entered this value into a cell on my worksheet. It is referencing a cell in another worksheet on a shared drive on my network.

='\servershare$[doc1.xls]Sheet1'!$A$1

All is fine until I re-open the document, whereby it has changed to:

='\serverusers$share$[doc1.xls]Sheet1'!$A$1

I have been advised to set the hyperlink base as \servershare$

...but this clearly does not work.

View 4 Replies View Related

How To Change Base Unit Of Charts

Dec 11, 2013

I'm working on a charting application that uses Office charts. I'm wondering what are some of the main reasons people change the base unit from the default, and how common that is.

Some reasons I've identified on my own:You're comparing different monthly metrics, but they could be recorded on different days of the month.Get a zoomed-out view.Compare the max value of each month.

View 3 Replies View Related

Return Value Base On Top X Highest Rank

Dec 18, 2013

I have done many research online to cater to my require but fail to accomplish it. I need to determine the decision base on ranking of the number in the Rank column. which is than reflected in the calender. But per day basis, it needs to only be green for the top "number of quota set per day" highest ranking. I have also attached the sample for a clearer understanding

Sample.xlsx

View 4 Replies View Related

Time / Frame Fps Formula (base 75)

Jan 18, 2010

I have a formula that calculates only seconds and frames. The frame rate is 75 fps (0-74).

e.g., 49.50 is 49 seconds 50 frames. It will not parse Minutes.Seconds.Frames, e.g., 1.49.50 is 1 minute 49 seconds 50 frames.

What my existing formula does is converts the number to all frames then converts the answer back to seconds and frames.

I need this formula to include minutes in its calculation.

A copy of the spreadsheet is here: ...

View 14 Replies View Related

Formula - Calculate New Base Pay Rate?

Dec 27, 2012

I am trying to calculate a new base pay rate, but I need it make sure it is at least brought up the new minimum and capped at the new max of the range where applicable. The increase is based on 10%

So here are the columns used:

L = Current Base Pay
Q = New Min of the range
S = New Max of the range
U = where I want to calculate a 10% increase of L, but ensuring it is brought up to at least the min (Q) or not over Max (S). In other words if my min is $12 and Max $18 and my new base pay is $16 -- then I am good. However it if is $11.50 I need the formula to return at least $12. And visa versa -- if the new rate would be $18.50, I need it to return no more than $18.

View 3 Replies View Related

Delete Row Base On Cell With Specific Value?

Oct 4, 2013

I have a macro that delete's a row when a cell in that row contains a specific value. I am unable to make the macro work automaticly when the file opens.

Sub Delete_Rows()
Dim rng As Range, cell As Range, del As Range
Set rng = Intersect(Range("A1:F400"), ActiveSheet.UsedRange)
For Each cell In rng

[Code].....

View 3 Replies View Related

Create Rank Base On 2 Variable

Feb 3, 2008

I hv following table :-

Summary Report  FGH1how urgent How ImptRank2highHigh 3midhigh 4LowHigh 5highmid 6Midmid 7Lowmid 8Highlow 9midlow 10lowlow Spreadsheet FormulasCellFormulaF1=+'Mega_Variable (#1)'!R4G1=+'Mega_Variable (#1)'!R5F2=+'Project (1) '!U63G2=+'Project (1) '!U64F3=+'Project (10)'!U63G3=+'Project (10)'!U64F4=+'Project (12)'!U63G4=+'Project (12)'!U64F5=+'Project (5)'!U63G5=+'Project (5)'!U64F6=+'Project (7)'!U63G6=+'Project (7)'!U64F7=+'Project (9)'!U63G7=+'Project (9)'!U64F8=+'Project (4)'!U63G8=+'Project (4)'!U64F9=+'Project (2)'!U63G9='Project (2)'!U64F10=+'Project (3)'!U63G10='Project (3)'!U64 Excel tables to the web >> Excel Jeanie HTML 4

I need code , when run it will fill in the ranking number :-

Summary Report  FGH1how urgent How ImptRank2highHigh13midhigh24LowHigh35highmid46Midmid57Lowmid68Highlow79midlow810lowlow9Spreadsheet FormulasCellFormulaF1=+'Mega_Variable (#1)'!R4G1=+'Mega_Variable (#1)'!R5F2=+'Project (1) '!U63G2=+'Project (1) '!U64F3=+'Project (10)'!U63G3=+'Project (10)'!U64F4=+'Project (12)'!U63G4=+'Project (12)'!U64F5=+'Project (5)'!U63G5=+'Project (5)'!U64F6=+'Project (7)'!U63G6=+'Project (7)'!U64F7=+'Project (9)'!U63G7=+'Project (9)'!U64F8=+'Project (4)'!U63G8=+'Project (4)'!U64F9=+'Project (2)'!U63G9='Project (2)'!U64F10=+'Project (3)'!U63G10='Project (3)'!U64 Excel tables to the web >> Excel Jeanie HTML 4

View 9 Replies View Related

Open Worksheet Base On Cell Value

Feb 11, 2009

I have multiple worksheets that call one userform.

Each worksheet has a specific word in cell J1 that matches a worksheet name.

How do I select a a sheet based on a cell value in J1?

Code: .....

View 9 Replies View Related

Macro: Base Row Number On Cell Value

Nov 20, 2006

I have a macro that has following line

Range("C38'").Select

I want to dynamically change the C38 to may be C37 depending on a value in a cell i.e. F1

so if the value in cell F1 is 31 then I want this statement to look like

Range("C31'").Select

View 3 Replies View Related

Base Pivot Table Off Different Ranges

Dec 7, 2006

I need to read consantly changing shift time/ covered data from a Pivot Tables pivot chart and populate this data into number of shifts covered/ uncovered. This information is then put into a chart over a 24 hour period (from 0700 to 0700). I have been populating the data from the pivot chart by hand by referencing the number of shifts in the covered line and dragging it to correspond to the shift time data part. I then have to do this for the uncovered shifts. As the data in the pivot chart is constantly changing, i need to do this data ransfer 'automatically'. I have started to look at and learn VBA, but i am getting nowhere fast. I enclose a worksheet (blank) to give you an idea fo what i am trying to do.

View 4 Replies View Related

Base Multiple Charts Off One Range

Jun 27, 2007

I have a chart that I want to be the same across multiple worksheets. The data ranges don't move, but the data may be different. It is cumbersome to go and retype the name of the sheet every time this chart is placed.

I have tried using named ranges. My named range X is !$A$1:$A$30 so that it will refer to the active sheet. If I place this in cells on the spreadsheet, it works. If I place "=X" in the values entry for the source data of the chart, I get a formula error.

View 9 Replies View Related

Multiple % Discounts Off Base $ Price That Do Not Cascade?

Mar 3, 2014

Cell B23 contains an invoice base price in $'s formatted to 2 x decimal places Cell I4, I5,I6,I7,I8 all contain various percentage discounts formatted to 2 decimal places

I am trying to creat a formula in cell I23 that will subtract the discount of each of "I" range cells - lowest number to highest- in order. But each discount has to be subtracted from original invoice value in cell B23

Example:-
Cell B23=$1660.00
Cell I4=14.00%
Cell I5= 3.50%
Cell I6= 3.00%
Cell I7=1.50%
Cell I8=2.00%

I have tried using =B23*(1-I4)*(1-I5)*(1-I6)*(1-I7)*(1-I8) But this appears to be a cascading discount By my manual calculations answer should be $1261.60 But above calculation gives me $1289.94

View 1 Replies View Related

Calculate The Delivery Charges Base On The Table

Feb 25, 2009

what i trying to learn is that im trying to get the delivery price calculate base on the delivery area(F10) and the total qty of the items(G10).

but i've tried with Vlookup, IF, lookup, Hlookup function and i still cant manage to get the right one to put the data in the H10

View 4 Replies View Related

Add Number Of Occurances Base On Criteria On Two Columns

Oct 3, 2009

How can I add the number of remarks to the number classes based on their row?

I have a TALLY SHEET which auto computes the number of occurances of each classes
and remarks…can someone help me how to add the class and remarks? In this example
you can see that CLASS A occurred 3x ,YES remarks occurred 2x and NO remarks occurred 1x for A class…

how can I add the occurances of YES and NO remarks to A class?

This should be the output…Remarks are being added according to the class they belong

ABEYESNONot Applicable
643242

View 13 Replies View Related

Count The Number Of Occurance Base On Criteria

Oct 7, 2009

how to count the number of occurrences base on a criteria? My sample file contains a Tally Sheet and a template sheet...how can i count the number of occurrences of Yes and No per class? Say for the A class, how can i count the yes or no?

View 2 Replies View Related

Save And Enumerate Base On Existing Files

Nov 9, 2009

I have this macro it save to specific location but if the file name exist then macro fails or wants to overwrite existing file I will like to make this macro to add a number

So It will look like this
DISCONNECTED # 11-09-09.xlsx
DISCONNECTED # 11-09-09 2.xlsx
DISCONNECTED # 11-09-09 3.xlsx
DISCONNECTED # 11-09-09 4.xlsx
DISCONNECTED # 11-09-09 5.xlsx

View 3 Replies View Related

Highlight Entire Row Base On A Single Cell Value

Feb 12, 2010

i have it to where is highlighting a single cell i will like the macro to highlight entire row base on a single cell value.

View 2 Replies View Related

Conversions To & From Feet-Inch To Decimal/base 10

Nov 14, 2009

I often use feet and inch inputs for calulations. I prefer to input a typical feet & inch input into one cell using this format: ft-n.

example: 12ft 9in would input as 12-9

This would need to be converted into a decimal for calcualtions. Also I would like to convert from Decimal back to ft-in.

View 9 Replies View Related

VBA- Create A Macro That Will Change 1 Of The Base Salary

Jan 28, 2010

Lets say I have

Admin:
Base Salary
US Duties

Consultant:
Base Salary
Senior Advisor

Is there a way to create a macro that will change 1 of the Base Salary(s). I need one of them to be Base Salary - Admin, or Base Salary ' or something different for my vlookup.

Will this macro work for each different tab I have?

View 9 Replies View Related

Base Listbox Fill Range On Selection Of Another

Oct 30, 2009

Have 2 listboxes, the contents of the second (fmmultiselectmulti) is populated based on selection of first. Sometimes (50%) when I open the workbook I receive a "Object Required" runtime error..

Private Sub ListBox1_click()
Select Case ListBox1.Value
Case "All"
ListBox2.ListFillRange = "_Sheet2!A1:A1"
Case "A"
ListBox2.ListFillRange = "_Sheet2!B1:B18" <--- example of line that gives the 424 - Oject Required
Case "B"
ListBox2.ListFillRange = "_Sheet2!C1:C18"
End Select
End Sub

Looks as though sometimes when it runs, listbox2 is not yet initialized ?? If I go into Debug and look at ListBox2 it shows up as type "Variant/Empty" and not " ListBox/ListBox" ??!!?? Is this some type of timing/race condition on the loading of controls ? I'm out of idea's. Both listboxes are on the same worksheet (Sheet1). The ListFillRange for Listbox1 (which is a fmmultiselectsingle) is hardcoded and also references a range in _Sheet2 - no problems with this control.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved