I am trying to set up a database to collect information on students behavior. We need to collect the frequency of 3 things-time of day, behavior, and correction. Can I do this in Excel? How? Is there a way to write a correlation that will count the occurrence of words?
View 9 RepliesI want to setup a worksheet that I can search the name of the comic book and the number of the book and have the results underneath the search criteria. I am attaching a sample workbook. On the search database sheet, I have setup how I would like the page to look.
The spots where Enter Comic Name and Enter Comic Number I would like to act as search boxes, as in Google.
I would like the Search and Clear to be buttons.
Is it possible to return the results I want? And can I keep my searches until I push the clear button? If not I will get rid of the clear button.
The last thing I want to see if possible is once I get a result, can I add a button to go to that comic books location to enter data. Or add a save button so I can edit any info right on the search page and save it in the database.
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.
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))
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
What formula could I use to return the following results.
1, 2, 3,4, 5, 6 = Manhattan
7 through 12 = Bronx
31 = Staten Island
What I want to be able to do is set up a thing that when you're in the excel sheet you click on it. Up comes a box where you can enter data and when you click submit. It puts that data back into excel spreadsheet. I have attached a spreadsheet to show what I mean. I have deleted some stuff that are unnecessary so don't worry about them.
What I need is for you to click a button that will create a new row/copy into the next row, from A9-AH9. Then the button will automatically bring up a box that will ask for Time, Timber, Clay, Iron, Warehouse, Hiding Place and then will enter that data into there respective cells which would be D20, F20, I20, L20, O20, Q20 respectively. That is the main idea. maybe it would be better to have te button come up with a box asking for the information and then will create the row and insert the data. If it's easier you can just do the box with just time or something so it's easier. I can then do the rest.
Tyvm. This to me seems really complicated so not sure how you would do this at all. i've looked at other stuff on the internet but haven't gotten anywhere.
P.S. If you have a more generic thing similar to this then show me the code for that or upload it and I can change it too suite my needs.
This macro was working just fine, now it generates an error on the line in red.
View 2 Replies View RelatedIt looks like this (log(X/Y))/log2. The X and Y are celldirections (E2 or F4 and so on). How do i setup that formula in excell?
View 2 Replies View RelatedI have the word "Gross" in a cell at the end of each month on one sheet. I need to calculate totals for each month above this columns so lets show it as this:
A B
1 100
2 150
3 220
4 300
Gross 770
How can I set up a macro to always calculate what my gross is setting a condition to find "Gross" and then somehow select the cells above it up to A1? I will have another cell as "Gross" for February under the rows of information for January. I am not at all sure if this can be done.
How do you set the range with whats below? Right now its looking at 4,2 only and if extend to look all the way to 19,2 it will just copy the whole screen. I need it to look at 4,2 and then move to 5,2 and then so on once it has copied all that information to the sheet ...
View 7 Replies View RelatedI just received a massive worksheet full of information for mailing labels. It's all in columns-which is excel. Is there an easy way to set this up for mailing labels? I've tried to import it into word, but I'm not getting anywhere. Is it possible to change the way excel displays the cells? To a point where I can have the address beneath, then the state, zip, etc?
View 9 Replies View RelatedI have an excel workbook with multiple worksheets(tabbed across the bottom of the workbook). How can I set up a menu of the worksheets on the left hand side of the workbook that enables me to jump to that worksheet?
View 4 Replies View RelatedI have a problem with an file that I have exported from another software program (I believe in CSV). The file seems to be in tekst format but I can not change it to date format. I need to know which weekday is which date. So january 1st is a tuesday and so on..
View 4 Replies View RelatedI am setting up a few spreadsheets for a restaurant I work at and I am stuck on an excel matter. I am trying to have an ordered number transfer to a new spreadsheet that will apply that ordered amount to a monetary value. So all my cooks would do is put the prep list on dropbox and it would take the ordered amount by the recipe cost to get an invoice for that day.
Example:
1st Sheet 2nd Sheet 3rd Sheet
Prep List: Recipe Costings: Daily Invoice:
Sausage - 2 x Batch Sausage - $229.03 $458.06
Pesto - 3 x Batch Pesto - $74.04 $222.12
How can i set the range for the Sheet3 i have taken IngDataColumn. It select only particular column of fixed that is 4
[Code] ....
I have looked for a way to set the print area of a worksheet through vb.
I would like it to find the last row of the worksheet and set it to be printed.
Some of the examples take it beyond the last row of data, because the the code that may be in the empty cells.
HTML Code: [URL] .....
If I want to set a global variable when I open my workbook which will be used in code on the individual spreadsheets, how would I do this? I want to set the time the workbook is opened to a variable (constant) and then compare that time to current time on each calculation in the worksheets.
I'm using Excel 2000.
I have a WorkBook with each sheet being a calendar month. I want to set the ActiveSheet as the current month so each time I open the WorkBook it opens to the current month WorkSheet not the last WorkSheet I was viewing.
View 12 Replies View Relatedhow to write code to set page breaks every 4th column, or in certain intervals. For rows I have a simple .FitToPagesTall = 1, but I'm looking for something more dynamic for the columns.
View 4 Replies View RelatedI am wanting to create a function, callable from a worksheet, that sets the background colour for any given range of cells to a given RGB value. I am confused about the Color and ColorIndex properties. I'd have thought the following piece of code was trivial and would work but it doesn't.
View 4 Replies View RelatedI have a userform that is called by clicking on a button and it copies the value in cell A to my userform. This works great it is called via:
View 5 Replies View RelatedI have a userform with several inputs which are validated, and should the input be invalid an ErrorProcedure is run. This basically displays a message telling the user what is wrong, and it should also be highlighting the text in the relevant field, but for some reason it is not doing that.
View 6 Replies View RelatedI have a userForm and I use a load, set the field defaults and show sequence to use the form. I want to be able to set the initial field (a "setFocus" didn't work) and then how pressing the tab will move through the fields.
View 2 Replies View Relatedi would like to set a criteria bewteen a ranges. eg If A1 >0 but <100 then .3, Else If A1 >99 but <200 then .6, Else .9. How do i write this in the cell?
View 4 Replies View RelatedThis should be easy ... can't figure it out. If I want a formula that wants to perform an action (NPV, but I don't think that matters) on the cell directly above and the next "X" (say 20 cells/years of cash flow) to the right of it, how can I set it up so that I can copy the formula across as well as change "X".
(Obviously, it's easy to select a 20 cell range and copy it across ... but what if I want the length of the range to by dynamic (ie I want to switch to a 40 year NPV instead of a 20 year)?)
I need setting up a vlookup with using two cell
One cell will have a 1,2,3,4,5,exc.....
Yhe other cell will have a name
I've been looking at code a lot here and at the end I always see people ending their VBA code by setting the variables to nothing. Why is this done? Don't all the variables in the sub automatically get trashed when the sub ends?
So what would be the difference of me doing:
Code:
Sub emailUser(strSubject As String, strMessage As String)
'Allows you to email the user if an error occurs instead of giving a messagebox
'and stopping everything. This way if something can not be checked out, you know
'what happened and can redo it the next morning (or fix the error if need be)
Dim olApp As Object 'Outlook.Application
Dim Msg As Object 'Outlook.MailItem
[Code] .....
vs
Code:
Sub emailUser(strSubject As String, strMessage As String)
'Allows you to email the user if an error occurs instead of giving a messagebox
'and stopping everything. This way if something can not be checked out, you know
'what happened and can redo it the next morning (or fix the error if need be)
Dim olApp As Object 'Outlook.Application
Dim Msg As Object 'Outlook.MailItem
[Code] ........
I have a commandbutton which sends my selected row in an email to a recipient as a reminder that they need to act on information in the row.
When the function runs i want to to add a date that the reminder mail was sent in a specific cell on that selected row. However i am having trouble.
Cells(SelectedRow, "M").Value = %DATE%
I've tried some different things but i cant figure out how to handle the arguments for Cells() to point to my actual selected row.
I am trying to set an Array to prompt user with a series of questions and input answers into a specific row. However, I want to skip over certain columns and leave those blank. How would I modify my code to do this?
Code:
Private Sub CommandButton2_Click()
Dim ArrQues() As Variant
Dim ArrInput(2) As Variant
Dim lngLstRow As Long
Dim strPNfromSales As String
ArrQues = Array("Enter the Part Number.", _ "Quantity Being Returned?", _ "What is the Reason for Rejection?")
For b = LBound(ArrQues) To UBound
[Code]...
I want the first two questions to be input into Column B & C, but then the third question to be input into column I.