is there a function that will return the specific content of the cell. like for example, i have a cell that contains the word DOG(a1), and on the other one is a sentence like THEDOGBARK(b1)...the function must find the word dog and must put it in another cell(c1).
find (a1) to (b1) and display the word in (c1)...
ex1.
a1 = dog
b1 = thedogbark
c1=dog
ex2.
a1=bark
b1 = thedogbark
c1=bark
ex3.
a1=the
b1 = thedogbark
c1=the
I'm using VBA to upload the open workbook to app.box URL which is working great! Since I'm pretty new to VBA, I can't figure out how to get Excel to display the sucess/failed message from the server to the user. I used the VBA POST upload module from this awesome tutorial, but I can't figure out how to return the message to the user. I did figure out that on the website there is an "id="after_upload_message", not sure if that works. My code is below.
[Code] ......
I am trying to attach an Excel file to a post. I found the following in FAQ: "To attach a file to a new post, simply click the [Browse] button at the bottom of the post composition page, and locate the file that you want to attach from your local hard drive" But I cannot find the [Browse] button. I should have said "to attach a file" not "to attach a post" in the header.
View 2 Replies View Relatedfollowing on from previous post (http://www.excelforum.com/excel-prog...g-up-form.html) what if the selected cell is a merged cell (cell count is greateer than 1), what is the best solution to enable double click event on merged cell ?
View 2 Replies View RelatedSheet1
Upon clicking any cell in Sheet1, it will automatically filter based on cell A and B.
Sheet2
Automaticall display filtered criteria based on double click from Sheet1
For example: when I double click on C1, on Sheet2 will automatically diplay filtered data based on A1 and B1 and same thing goes to if I double clik on C2 on Sheet2 will automatically diplay filtered data based on A1 and B2.
Any escape characters in Excel. I'm trying to do something like this:
=FIND(""",A1)
I have two columns in a spreadsheet.
In cell "$D$3" is the word "Period 1".
I want to be able to do the following.
Double click on cell D3, where the word period 1 is.
VBA then looks up that period in column B, and finds the corresponding weeks for period 1 from column A.
I then want VBA to list these weeks next to the period 1 I double clicked, so in column E.
I have attached a spreadsheet as an example.
I have a spreadsheet in which I am trying to track invoices billed according to month in question. For example, I need to find total invoices billed in February for ABC Consulting Company. I have a database in the same spreadsheet that contains all invoices billed for an entire year for all companies. How do I pull invoices for a particular month only, in this case for the month of February? I have attached an example of spreadsheet in question. Included is a tab which indicates desired results.
View 5 Replies View Relatedcreating a .Find code to search a range on a sheet and then display each result seperately in a msgbox. An inputbox will be the value .find searches the range for.
the msgbox needs to be a vbyesno
VB:
'SEARCH CODE
Dim myItem As String, myRNG As Range, NewLoc As String
Dim Found As Range [code].....
formula to tell me 9 values. These values are on 9 separate tabs/worksheets. They are always at the bottom row in a specific column - but the row changes every week. I have a totals tab in this workbook. I would like to stop manually going to each tab and pressing Control+End to see the total and manually going back to the totals tab to enter the value. Is there a formula to find these 9 values automatically and display them on my totals tab?
View 6 Replies View RelatedWhat's the formula that will search a column of values and "pull out" only one of each unique instance? The expected result, then, for the following data-set would be 4,5,6,7,8,9.
4
4
4
4
4
5
5
5
6...........
In col A, I have the dates. I would like to create a formula in all the other columns in row 1 that will look fror the first instance of a value in each column and return the date that that threshold value is reached.
The value I am looking for is 3, but the values in the columns might look like 0 1 1 1 3 2 1 3 4 2 0 etc. I want to return the date of the FIRST instance of 3. How would I do this?
I need to find the last value cell in a row and display its contense. Is OFFSET the best way of doing it? Cell H3 will need to contain the formula and the row to seach is also row H. In H3 I want the value that is found in the right most cell on row H that contains anything.
View 3 Replies View RelatedI may be making this more complicated than it needs to be but I can't seem to figure it out. The goal of this spreadsheet is for General Managers of a restaurant to give feedback about food deliveries. These deliveries usually come on Monday, Thursday, and Saturday, but could for a list of reasons come on any day of the week. I want to automatically populate as much information as possible without requiring GMs to remember and enter dates.
A1 is =TODAY()
A2:A5 is a drop down where the GM selects the day of the week the delivery arrived. i.e. MON, TUE, WED, etc. I want the corresponding date of the past week to auto-populate in this cell (or even the adjacent cell if necessary) once the day is selected. For example, if today is 3/8/2014, when MON is selected in A2, I want the cell to automatically add "3/3/2014," making the entire cell read "MON 3/3/2014."
So if said GM is filling in this spreadsheet on a Saturday, and I want to display the date of the previous Monday, I need to find the day of the week of A1 (WEEKDAY function), and make A2 = A1-5.
If today is a Friday, it would be A2=A1-4, and so on for the 7 days of the week.
Then I would need to do all of this for if a Tuesday is selected in the drop down box, meaning IF(Saturday)Then A2=A1-4, etc...
I was trying to string together IF statements like this:
=IF(WEEKDAY(TODAY()=7),A1-5), IF(WEEKDAY(TODAY()=6),A1-4)
It works when I do only the first IF statement, but when I add another it returns #VALUE. I thought that excel would find the first true value and stop evaluating.
I have a spreadsheet and in column D, I have look up formula which looks up value from another tab. What I want to do is if the look up finds #N/A or blank cell. There should be a message box appear warning that all the cells in column D might not be updated properly.
View 4 Replies View RelatedIn my file i can insert text to a certain cell and column but this is for one entry only. I am wishing for a run that for every entry, there is a new row.
Here's my file sample project.xlsm
You can see there the user form for a post entry. The user should fill-in code and description and if he hit save, the code and the description should be recorded on list provided the sheet.
I'm not that clued up on VBA or macros but I do have a few i regularly use, I’ve found a thread related to my problem but cant make much sense of it.
Basically i want to post the 3 cell values (C5,C7,C9) into row B20,C20 and D20 respectively. However I want these values to form a list staring with row 20 and working down onto the next available/empty row.
Marking My Post As? How do i mark my post as solved?
View 5 Replies View RelatedNot sure how too do this, here is a simple example of what I want too do. Just using different buttons to post a number.
View 6 Replies View RelatedI have a list of UK Post Codes that I wish to filter but because of the format I'm getting problems.
The reason is that I'm only interested in the first part of the post code.
Example: Using IP7 6NH and IP32 8LR. If I tried to filter those using greater than then Excel would treat IP7 6NH as larger then IP32 8LR because 7 is larger then 3.
The post codes are all imported from another piece of software and are always in the format of 3 or 4 chracters, then a space and then 3 more chracters. I wish to create another column which only has the first part in it. So I wish to crop IP7 6NH down to just IP7 and IP32 8LR down to just IP32.
Then I want to make a further column which looks at the value in the first new column and returns "In" or "Out" based on some conditions.
These are the conditions. If the cell begins with CO or NR or CB or CM or PE, regardless of the rest of the value, then "Out" should be returned. If the value is between IP1 and IP6 inclusive then "Yes" should be returned.
If the value equals IP7 then "No" should be returned
If the value is between IP8 and IP17 inclusive then "Yes should be returned.
If the value is between IP18 and IP29 then "No" should be returned.
If the value equals IP30 then "Yes" should be returned.
If the value is bewteen IP31 and IP33 inclusive then "No should be returned"
I'm think that it's quite complex and maybe the way to go would be to have two other columns, one containing the "In" values and the other containing the "Out" values, that a formula can refer to when making it's yes or no choice but I don't know how to do that.
I may have missed it, but I can not seem to find where I can customize Excel to add a "paste formula" button. (I have a fair amount of copying to do where I do not want the formats being changed at the same time.)
View 9 Replies View RelatedI have the following code. It takes data from one sheet and inputs into another. When I enter a Customer ID in cell G12, starting on Row 18 and proceeding down, jobs are listed. When the macro posts into the history sheet, it posts the jobs in rows. I wish for each time I run the macro, the info is all in the same row whether theres two jobs or 20 for that customer ID. Right now it is posting like this (two jobs listed):
CustID(G12) | Name(B12) | Address(B13) | Job1(A18) | Job1Date(D18) | Job1Price(G18) |
CustID(G12) | Name(B12) | Address(B13) | Job2(A19) | Job2Date(D19) | Job2Price(G19) |
Im trying to make it look like this:
CustID(G12) | Name(B12) | Address(B13) | Job1(A18) | Job1Date(D18) | Job1Price(G18) | Job2(A19) | Job2Date(D19) | Job2Price(G19) |
Sub InvoiceUpdateHistory()..................
Is there a way with a formula to have a result of one cell pasted in a different cell? ie. C1's formula =if(and(isnumber(a1),isnumber(b1)),b1-a1,if(and(isnumber(a1),isblank(b1)), b1 = d1,"")
A B C D
12/18/06 formula above =today()
if b1 isbalnk it will copy the value of d1 to b1. I dont know if this can be done i have looked at offset and a few others but it doesnt look like this can be done but want to see if i have over looked domething
If the user clicks on a cell within a specified range ("DataEntryWindow") which contains formulas, I want the formula RESULT to be copied on to the formula bar for that cell (not in to a cell) - the user can then press enter to replace the formula with the result, or escape to cancel
- you can do this manually by copying the cell as values to another cell, then copying that value to the clipboard letter by letter, then clicking on the original, clicking F2, selecting all the formula text, then pasting the clipboard!
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("DataEntryWindow")) Is Nothing Then
curval = Target.Value
Application.SendKeys "{F2}"
'Application.SendKeys "???" ' some keyboard combination to go left, left, left
Application.SendKeys curval
End If
End Sub
Needless to say, it doesn't work. sendkeys seems to do nothing at all. is there an object in worksheet for the formula bar that i can paste to?
I am trying to read a value in a cell to post in another sheet.
Once the value has been copied, end. However, if the cell to the right of the copied has a value, then that value should be copied instead.
If the cell is blank, then the information should not be copied.
Basically I have a string of data from left to right being populated, with the most current value being copied to a differnt sheet.
I am creating a 'add supplier' userform, in which i open the userform, type in the new suppliers information, then press submit.
The problem is that the data i enter deletes the data that i previously entered into row 26 instead of posting the data into a new row (I wish it to be 27, then 28, etc)
Here is my current code for the userform
VB:
Private Sub CommandButton1_Click()
nextrow = 26
Sheets("Suppliers").Cells(nextrow, 3) = UserForm5.TextBox1.Value
Sheets("Suppliers").Cells(nextrow, 5) = UserForm5.TextBox2.Value
Sheets("Suppliers").Cells(nextrow, 6) = UserForm5.TextBox3.Value
Sheets("Suppliers").Cells(nextrow, 7) = UserForm5.TextBox4.Value
[Code]....
From the attached data is it possible to create a formula to count the number of staff in post that are line managers?
View 7 Replies View RelatedI am in a process of creating a excel based productivity for my team. This workbook has 2 worksheet, one is QA productivity tracker which is accessible to all, after the information is filled i want to store it daywise in a master tracker (next worksheet).
I have created a macro which copies the information to master sheet, but the challenge i am facing is that at every execution, macro should paste the data in next row.
I want a user to be able to manually enter a formula into an input box which will then be used for other code elsewhere?
I have the following code but it does not want to work
HTML Code:
Dim fFormula As String
On Error Resume Next
Application.DisplayAlerts = False
[Code]....
I believe it was yesterday this board had a post how to lock and protect cells with data and leave them unlocked and unprotected if they're blank, but I can't find it. Does anyone know where it was?
View 9 Replies View Related