Creating Reactive Searchable Database?
Jan 2, 2013
I would like to be able to create a reactive, searchable database. I have data that will be broken down into two divisions: Origin and Destination States. I would like to type in an Origin State, then a Destination State, and then have the document provide results for matching data. For example, if company 1 is in the origin state, but not destination state, its data will not be shown in the search result. However, if company 2 is listed in both the Origin State and Destination State, its data will be listed.
Addition - Attached is a small example of the worksheet that I would like to create. In the "SEARCH" tab, I would like to enter the Origin and Destination States. the search would yield all appropriate matches. In this example, if I entered Alabama as the Orign State, and Arizona as the destination, the search would provide the following match:
GreenLine
H&M Bay
Refrigerated Express
View 1 Replies
ADVERTISEMENT
Sep 14, 2006
I am a DJ and I want to allow my prospective customers to view my music library, while preventing my competition from printing a copy, or posting my library as their own. I think I can accomplish this by having a Java (or similar) interface on a page of my site that allows the user to search songs by title or artist. However, I am lost as to how to make that happen.
A competitor has something pretty close to what I want, but cannot get enough info about how to do it myself when viewing his source code (http://www.houstonkaraoke.com/search-pro/prodb.htm). I would like something a little more asthetically pleasing. My DB is in Excel 2000 and I am running XP.
View 3 Replies
View Related
Aug 20, 2009
when it comes to using an excel sheet (which is already built and rather large) for functions which are more suited to database functions.
The excel contains audiotaped medical info in columns:
question
physician name
diagnosis/subject
timecode
label1 (checked box "on")
label2 (checked box "off")
comments
each of these are sectioned by audiotape with headers --
looking something like this --
TAPE 1
diagnosis/subject1
then under that, columns
question | physician name | timecode | label1 | label2
then
diagnosis/subject2
then under that columns
subject/question | physician name | timecode | label1 | label2
then
TAPE 2
with similar info
so each TAPE has numerous DIAGNOSES covered under which there are various questions asked and answered by individual doctors.
(see link to dummy file for visual)
[url]
I need to be able to search on a group of criteria simultaneously:
# physician’s name
# subject
# on-label
# off-label
and return the soundbite in a user-friendly way so that the entry-level desk people (with little or no excel expertise) can retrieve it.
YES, it was not set up to do this, but this is what i've got. so i'm hoping that before i go down too many dead-ends, someone can tell me which is the best way to do this.
Looks like VLOOKUP can only really search on one column and filters would require too much expertise for entry-level employees, but should i look into VBA or Macros. or do i need to import this into Access -- or learn SQL to interface with it on a user-friendly website?
View 9 Replies
View Related
Mar 31, 2004
I am currently trying to create a database of products for my company. For each product I would like to include an image associated with it. I then want to have on another sheet a place where the user will click an error and be able to cycle through the products. As tehy cycle the associated image will pop up.
What I need to understand is after importing the image into excel, how do I associate that image to a cell so I can reference it in another sheet of the database. I am not concerned with how large the database will get, my pictures are quite small.
View 4 Replies
View Related
Apr 30, 2013
This is my invoice. I want to be able to create a database record of every transaction. In the end I want to be able to export this data into Access, but it needs to be in sequential rows and columns. I want to be able to list the cells on Sheet 1 that have Data in them in the configuration on Sheet 2 that I have listed. What I need to keep in mind is that someone might have 1 item in a transaction and others might have 5. So I need the ShopID and Customer information to appear in front of every item listed in rows 20-27.
A
B
C
D
E
F
G
H
1
ShopID Data
[Code]....
View 1 Replies
View Related
Jul 1, 2013
I am working on creating a medical master database. I have a master sheet with a huge number of columns. I have a couple of guys working with me, and they have their own sheets in the workbook.
So here is what I would like to do: anytime one of the guys enters data into his respective worksheet, I want the data to be copied over to the master sheet in a new entry.
The columns among the worksheets are different, and I would like the data to automatically sort in the appropriate column on the master sheet when it is copied.
I have attached a copy of the workbook.
I have included an example of what I would like to see. For example, if Charles puts in an entry in his worksheet, a new entry is created on the master sheet with the information from Charles' sheet sorted in the appropriate columns.
View 8 Replies
View Related
Feb 9, 2014
create an excel spreadsheet, where i can enter all my products name, unit price etc. so when i am doing an invoice for the customer, if i just type the product name price will show up automatically.
View 4 Replies
View Related
Dec 28, 2009
I am working on a label printing set-up for my work. So far I have completed the userform that formulas will be entered on and printed from. I had an idea of being able to save these formulas for recall later. I included “Save” and “Recall” buttons on the userform. My plan is to have my co-workers click on the “save” button and be able to enter an additional piece of data and have everything saved to another worksheet labeled “database”. If you look at the said sheet you will see a column for “customer”, “color” and then the colorants. Due to the wide variety of colorants and quantities available, I set it up so that I have the colorant and under that Oz and 48ths. I am trying to figure out a code that will populate that across the row.
Then I want to be able to push “recall”, find my customer and then color in a combobox and have that populate my label.
At this time I am stuck. Part of my problem is I don’t quite know the terminology to google.
Attached is the file I am working with. The only sheets that need concern anyone are "main" and "database". The others are from the original file and I will be deleting those once I am done.
View 11 Replies
View Related
Dec 6, 2013
I have been creating a simple database to hold a record of attendance.
I'm now at the stage where I want to create a worksheet that cannot be modified; but rather is something the user can look at in a glance.
I need forming a SUMIFS formula that will look for monthly periods of the times late, sick, absent etc and add them up to return to one place.
So the dependants will be the month, the employee and the type of record (late, sick, holiday)
I have created a userform that I can use to add in the raw data, so I'm not sure what range I can create, as every time new data is added it finds the next available row.
Here is what I'm using so far: [Code] ........
What the Overview will look like : Overview.PNG
What the raw data looks like : Raw Data to use.PNG
Do I need to introduce a matched up column that has the employee name and date?
View 1 Replies
View Related
Mar 10, 2014
I am creating a spreadsheet utilizing the National Vulnerability Database (NVD) from NIST.
I am successfully able to import the xml files and have the xsd mapped fine.
My problem is within each xml files for each records(1000s of records) there are sub pieces to certain record parts. I.e. software versions (that will be different per piece of software) however they will always fall under prod vendor
"
"
Excel creates a new row for each of these.
How can I make it only create the 1 row and comma seperate those?
View 1 Replies
View Related
Jun 3, 2013
I have a 5 major categories of products e.g. Ketchup, Hot sauce ,mayonnaise , pizza sauce etc.
Now each of these individual categories are further divided into number of of subcategories based upon the the sizes and brands.
I want to create a sheet (One sheet) where I have to record production of each product on daily basis.
Like for example if I am producing ketchup, I select ketchup from drop-down list,Now in next column I have to select production size from predefined sizes i.e subcategories. But it should also be from drop-down menu and it should only show me the subcategories of my selected product like ketchup .I think this has something to do with data validation but I am not sure how this model will work.
View 3 Replies
View Related
Apr 2, 2014
I built a searchable drop down list in excel which will create quick receipts from a huge list of products.
I entered my products in one column and their respective content and price in the columns next to it.
My goal is to create a searchable drop down list which will include all of my products so that when I search and select the product my customer ordered it will ultimately pull the content and price with it to form a receipt with multiple products.
The problem I ran into is that my searchable drop down list cannot be copied to the multiple rows below.
Cell B8 is active.
EFS receipt drop down.xlsx
View 2 Replies
View Related
Feb 7, 2008
I would like to automatically update a 'yearly' database file with info from a file that is changed on a daily basis.
The daily file that i use has info like date, truck number, delivery stops, weight.
the database file has the similar headings.
at the end of each day this daily file is saved. I would like to have the info that is entered into the daily file automatically plugged into the yearly database file into the next available group of cells with respect to the salesperson.
This is kind of a generalization but i'm hoping to just get pointed in the right direction. If something like this involves vba then it will be beyond my ability and i'll have to do it manually, which is fine
View 9 Replies
View Related
Jan 23, 2014
I need the searchable list box to return data one column to the right of the "searched" column data.
This works mostly with Data Validation.
Named range "validationlist" with "=OFFSET(Choice!$AC$4,,,COUNTIF(Choice!$AC$4:$AC$14,"?*"))"
D9 has a drop down control. Enter the cell and type "br" and click the drop down arrow. Mouse to choose an item from the list box. If you chose "brown" , it will be entered in the cell. The returned item should be "banana" from the other column. How to do this?
Once working the control needs to be used across the row in more cells: E9, F9... all the way out to W9. And there has will be a Lookup to pull data from elsewhere above D9.
This worksheet ultimately needs to be uploaded to Skydrive and used as a collaborative worksheet as a 'web app'.
See attachment and formula output below.
[Code]............
searchableListBox-EF1.xlsx‎
View 2 Replies
View Related
Nov 7, 2008
I'm trying to lookup a database named database and return a time in column A, based on criteria in cells a1 and b1 on another sheet, A1 would contain a number and B1 would contain a day from mon-fri
eg of Database
A B C D E F G
10:00 5000 Mon Tues
11:00 5000 Wed Thur Fri
and so on
if a1= 5000 & b1=Wed
how can I return 11:00
I have tried index and match =index(a:a,match(a1&b1,b:b&e:e,0))
View 9 Replies
View Related
Oct 17, 2013
I've used a countifs, but I'm having trouble doing a sum in a similar way. I have 2 databases and I will try to explain below. I need the to sum the values of database 1 if the second database is >= 20. So the value I would expect on this example would be 900. I would also like to be able to highlight which ones are elliminated. Such as coloring the text red.
Database 1
Eric 100
Jenny 200
Gina 300
Doug 400
Database 2
Eric 18
Jenny 20
Gina 34
Doug 55
View 5 Replies
View Related
Dec 22, 2008
I am trying to build a selection for a procedure to use.
View 2 Replies
View Related
Jan 20, 2009
I use Microsoft office 2008 for MAC i currently have 4 xls witch contains clients
The one has 11.206 the other 11.971 and the other 4267 people
THe 4th and last list has 3462 and i need to check witch of the people in 3462 are not contained in the other 3 xls
I tried to copy - paste some info in order to be replaced by excel but nothing
View 9 Replies
View Related
Apr 2, 2009
I've been browsing through postings for a while now trying to figure out a solution to my excel formula problem. While there is a lot of useful info, I have not found anything that will get me where I need to be. I am hoping that someone here will be able to me out. My project is this.
-A workbook with about 20 sheets.
-Sheet one will be a master list of serial numbers with blank fields for dates, account numbers etc.
-Sheets 2-20 will be used to assign those serial numbers to individuals.
-On each individual's sheet there are fields for dates, account numbers etc. next to the serial number.
-I need the master sheet to look through the individual sheets and insert the date, account numbers etc. into the master sheet.
I can get the IF function to work with one sheet but cant figure out how to do this across multiple.
View 4 Replies
View Related
Apr 4, 2009
I want to set up a database which contains customer comments and phone numbers, what I want to do is every 30 days or so, have the cells highlighted so that they remind me to call them.
View 4 Replies
View Related
Feb 6, 2010
uses CSV files for importing product data, problem is both have it formatted differently. What i ideally need is a master file that i can change whenever a price needs changing or product adding, this feeds down into 2 csv files that are formatted for the relevent softwares and then i can use a macro to upload these automaticly at end of day. ive tried using just excel but had no luck, i tried using access and custom reports but keeping getting errors as page size is 35 fields long and doesnt want to export as a csv,
View 10 Replies
View Related
Dec 12, 2012
Using an existing database with nonfixed boundaries I am creating a new one with uniform boundaries.
The simple spreadsheet I will use in this comment isn't what the database actually looks like but represents what I am trying to achieve.
StartFinishAssigned #
0151
15252
25403
40552
55602
60804
80953
951002
Here I have the old data, organised into sections that have the same assigned number. (Note: the assigned number may be the same as the previous cell). I wish to change it into this structure:
StartFinish#
020
2040
4060
6080
80100
It will be organised by the start and finish instead of by the assigned number. Instead I would like the number to reflect the lowest assigned number that occupies a part of that area.Is it possible to create a forumla which would achieve this?
View 7 Replies
View Related
Oct 12, 2013
I have spreadsheets supplied by clubs to add data to a database. I am not a spreadsheet user,
Today I have a spreadsheet with the columns A to M repeated in the width of the spreadsheet.
How do I reduce that to one display?
View 7 Replies
View Related
May 11, 2014
From the data on my database I want a button to export certain columns (B,C,D):
1. that on the (column J) have number smaller than (cell A1)
2. and create PDF's based on a column that has 3 options (AA, BB, CC)
So all the data from database that make 1. true to be exported on 3 PDFs where the first PDF has all the AA data the second all the BB data etc..
Is this possible?
View 1 Replies
View Related
Jul 9, 2007
I have a big database that has different name in column A(something like Y1, Y2, Y3, Y4, Y5, Y6, Y7, Y8...). What i'm trying to do is to group them! In group A i have Y1,Y7, in group B i have Y2,Y3, in group C i have Y4, Y6 and etc! I think the solution is something like index...but i never worked with that in VBA! So each name of group A should copy on a new sheet, the next rows should come group B and etc! Is there a way to do that in VBA?
View 11 Replies
View Related
Nov 16, 2008
I have the following ....
View 14 Replies
View Related
Mar 9, 2009
Add Project to 'database' I recorded my marco.
View 3 Replies
View Related
May 12, 2007
I'm generally trying to figure out in my head most of the pluses and minuses for using Excel Worksheets as a database. In My case it means adding data from a UserForm to Excel cells and upon these data to analyze the info from the worksheets to other worksheets like charts, tables etc. Here's my view:
Pluses:
1. VBA and Excel integrate well as a whole, easy to use, well know interface
2. There're many available options to manipulate with the database once it's arranged properly in the excel worksheets
3. Don't need to give extra money software like Microsoft SQL etc.
Minuses:
1. Slower operating because it takes some more memory and processing time to reference the data in the cells. Here I mean operations between the UserForm(s) and the Worksheet(s)
2. You can have DB not bigger than 256*65000
3. XLS files are generally much bigger as a size -> slower work as a whole
4. Maybe (i'm not sure here) there're less tools and options than a real SQL software
What options I have:
1. Use some SQL DB which is free
2. Use Text Files to write and read from
View 9 Replies
View Related
Jun 25, 2007
I am trying to find functions that allow me to categorise game attendance by team and day. EG: Out of the list, I would like to summarise the min, average and max attendance for the Broncos on Fri, Sat, Sun and Mon games (and for each team)....
View 9 Replies
View Related
Mar 26, 2008
in summarizing my data set. specifically, I have names of organizations listed in once column and in one of the others I have status of organization (open, closed), number of transactions and volume of transaction by months for each organization. In a summary sheet I need a formula that would look up for a specific organization in the long data base and match it with its status and count the number of "opened"(or "closed") organizations matching that specific name as well as sum the total volume of transactions for that specific organization. If I stated my request unclearly i can explain it better or attach a excel sheet.
View 9 Replies
View Related
