Making One Worksheet Talk To Another
Dec 8, 2008
I know I posted this same topic about a week ago but I went through the first 20 pages on the forum and couldt find it, i tried the search option and nothing came up. I have several worksheets in the same workbook. When I enter a number in one cell in work sheet A, I want the same number to show up in a given cell on work sheet B. How do I do this? I can make words move from one shet to the next but numbers dont seem to be the same.
View 6 Replies
ADVERTISEMENT
Nov 26, 2013
I need to create a simple Talk Time Chart displaying our call center's talk time in 30 min increments.
TimeATT
08:00:00:02:03
08:30:00:04:06
09:00:00:03:56
09:30:00:02:57
10:00:00:04:57
10:30:00:03:29
11:00:00:04:41
[Code] .....
View 1 Replies
View Related
Oct 2, 2012
how to calculate average talk time in excel.
View 9 Replies
View Related
Apr 24, 2008
I'v got a school task about making a excel worksheet.
But we have just started and i havent gotten all the functions to work yet.
The task itself is :
Make function that tests if D9 is larger then 100 and I9 is less then 50. If true "Kontroll" if not "OK" should be written.
Also, if "Kontroll" shows up it should have a dark green "OK " should just be black
Its roughly translated from norwegian. If you need some more information I will try to provide it
View 10 Replies
View Related
May 12, 2006
Basically trying to make change the active worksheet using a macro code. I want the user to be able to click a button and it will automatically switch the worksheet to another within the workbook.
View 5 Replies
View Related
May 30, 2013
I would like the following code to be run for all those sheet/s that has a name = "single" (Not case sensitive neither an exact match) of my active workbook.
Code:
Sub UIUIUI()
Dim LR As Long, i As Long
LR = Range("I" & Rows.Count).End(xlUp).Row
For i = 1 To LR
With Range("I" & i)
If .Offset(, -1).Value = 1 Then .Value = .Value & "-"
End With
Next i
End Sub
View 3 Replies
View Related
Sep 3, 2013
I'm using Excel 2010. I have a workbook with only 1 worksheet in it and it will be sent to several people. I want that excel file to open in Full View when the end user opens it. Is this possible without any VBA codes?
View 2 Replies
View Related
Aug 28, 2009
In workbook A, I have 2,000 records, cleaned/de-duped
I have columns A, B, and C:
Blank|Truman school, San Diego |1234
Blank|Truman school, San francisco|1235
Blank|Truman school, Atlanta|1236
Blank|Nice school, Georgia|1237
Blank|Nice school, Raleigh|1238
I used =MAX($B$1:B1)+IF(COUNTIF($A$2:A2,A2)=1,1,0) copied down and deduped in order to get my results in Workbook1.
In Workbook B, I have about 6,000 records and they look like this in columns A,B,C
Laura|Truman school, San Diego | need id to match from workbook 1 for column C
Trevor|Truman school, San Diego|need id to match from workbook 1 for column C
Sandy|Truman school, San Diego|need id to match from workbook 1 for column C
Kate|Truman school, San francisco|need id to match from workbook 1 for column C
Rudy|Truman school, San francisco|need id to match from workbook 1 for column C
Sean|Truman school, Atlanta|need id to match from workbook 1 for column C
Mark|Nice school, Raleigh|need id to match from workbook 1 for column C
Tom|Nice school, Georgia|need id to match from workbook 1 for column C
View 3 Replies
View Related
Feb 3, 2010
I am making a simple map in excel. I have my floor plan on sheet 1 and the location of product on the floor on sheet 2.
Currently I have some formulas on sheet 1 that link to some sales data on sheet 2, but what I would really like to be able to do is use the search function on page 1 and it give me the location of the products in a given area.
The data is broken up into group location on the second sheet.
View 11 Replies
View Related
Feb 6, 2010
I have four columns containing about 200 addresses.
A Names
B Streets
C Cities
D Phone no.
If I write a name in D1 I want to get the corresponding street, city and phone no. in E1, F1 and G1.
I also want to copy the formula downwards let's say ten times so I can make a list.
If I for example just want to make a list of three names (D1-D3) I want the rest of the fields to stay blank.
View 6 Replies
View Related
Aug 2, 2007
I've created an Add-in (.xlam file) in Excel 2007 and installed and activated it (it shows up under "Active Application Add-ins" on the Add-in menu for new workbooks).
I can see the macros and code when I go to the VBA editor, but the macros don't show up in the regular macro list.
I know that I can write code for the new workbook that will reference the Add-in code, but I want other users to be able to install the add-in and run the macros in it right away without any knowledge of VBA. Is there a way to make this possible?
View 11 Replies
View Related
Feb 11, 2008
i made a claculator in vb.net, and now i have to make one in vba, what i did was as follows, first ill post the code from last year, then my vba attempt;
View 14 Replies
View Related
Mar 14, 2007
I have a spread sheet that tracks progress reports that are due every 90 days. I have a due date colum that will automatically get high lighted if the 90 days have passed to inform me or my staff that the report is late. I would like to have a colum with a button in each row that allows the reader of the spreadsheet to press "YES" for that accont's progress report having been turn in. When the "YES" button is pressed the date due date column advances to the next 90 day due date and the highlight would turn off.
I used the conditional format to change the due date column to Yellow if =TODAY() is less then or equal to the due date. But I can figure out a way to select something and turn the highlight off and advance the due date to the next 90 day due date.
View 9 Replies
View Related
Mar 30, 2007
I have been asked to make a formula that sums up the hours in a week and then tells me whether I am below or over the budgeted hours for that week!
I cant get it to work since I cant figure out how to have the same formula in all the cell that sums up early, mid and late shifts, ie 06-14, 14-22, 22-06.
The graveyard shift is a problem there since I get negative hours.
Further more, I need to have the formula ignore cells to be added up if it has letters in it, we write an R for Rostered day off.
View 9 Replies
View Related
Aug 20, 2008
............Beer........ Total
Stefan:....1........... 0,70€
Now i need a button that when i click on the name the amount 1 gets 2,3,4,5,6, ect and that it calculates the price up as a total
View 9 Replies
View Related
Jun 6, 2006
1- I 'm working with a table wit many Sheets.
I want to make a Report Sheet with selective ranges(cells)
the selective cells should paste as link ( in order to be updated cells)
2- then how to Zip this worksheet to zip file ( to save it)
3- If I have a Macro and i want to perform this macro to all sheet except one sheet how to that ?
View 6 Replies
View Related
Jun 15, 2006
I would like to:
1-Make Rows & columns 1/4" X 1/4"
2-Be able to enter dimensions into an input box that would then draw a square(or rectagle) with the inputed dimensions in INCHES.
View 3 Replies
View Related
Aug 21, 2012
In Column B of my spreadsheet i have a drop down that only allows users to enter "Yes" or "No"
Is it possible to make Column C a required field if "No" is selected in column B.
So basically if cell b4 is "No" then i want to make it manditory that cell C4 is filled out with a reason why.
Same thing for cell b5 then i would like cell c5 filled out before they continue using the sheet. etc.
View 1 Replies
View Related
May 6, 2014
I am a Coach who will be using this data table to call pitches via a catcher's wristband. The band is obviously completed below; however, I need to create a separate sheet where the numbers correlate to the pitches that are being called. How it works: everything in the table(s) with a dash is a pitch i.e. 2-1, 1-3, 1-U, etc. The numbers on the columns and row are what is relayed to the catcher to call the corresponding pitch. For example, I would signal is 113 (first number = row second number = column). 113 is 4-1. I need a way/ formula to where I can see which numbers are to be relayed in for each pitch. It would possible look like 2-1: 101, 411, 422, 501, etc.
View 5 Replies
View Related
Mar 28, 2014
I built what I can only describe as a fantastic spreadsheet. It wasn't until after that I realized it is 123 MB in size, but even for the complexities within it, it still feels like that is quite large.
I can't share the file due to proprietary reasons, but any general tips as to things I can do to make it smaller (and therefore faster to run).
I tried saving it as a binary spreadsheet and that dropped it to about 80 MB, but I don't really know what that does and if it will impact the sheet performance in any way.
View 2 Replies
View Related
Nov 23, 2008
i have a cell "h23" that must always start with a "j" or a "J"
the trouble is some of my users are only putting in the number
ie 2345 when it should be j2345 or J2345
View 3 Replies
View Related
Jan 11, 2009
I've run into an issue for which I can find no elegant solution. I consider myself a competent Excel user, so it's pretty embarassing...
What I want to do is to sum the values along the 'axes' of the table. In order to fully explain that, I'll give a small example:
Let's say, this is my source data
View 2 Replies
View Related
Jan 14, 2009
I have a workbook of contracts that I have designed in excel. Each worksheet tab/title is the contract number, i.e. 3487. On each individual contract I have the contact name, address etc. Each cell/field is in the same position on every contract. In other words, every B1 is the Group name, every B2 is the first name, every C2 is the last name, etc. What I'm trying to do is to make a new page with all of the contact info on it so I can make labels etc. I hope this is clear.
View 5 Replies
View Related
Apr 15, 2009
How do you make a cell appear blank when it has a formula in it refering to a cell that hasnt been used yet?
I would like some cells to be blank instead of having #N/A in them.
View 7 Replies
View Related
Jun 2, 2009
I have a table which as a few columns, the left column is called name and the far right one is called email. The name cells have a drop down list which refers to another workbook with peoples names, when you select a name other cells are automatically populated using the vlookup function such as phone number, email etc. In the workbook it is referencing too with all the data, the email address are like a hyperlink which creates an outgoing mail if you click on it, is there a way to have this in the table as nothing happens when you ckick on the text.
View 6 Replies
View Related
Sep 22, 2009
One of my colums has a list of customer Ids:
Example:
876541
876542
876543
876544
etc...
I just added a bunch of new customers, like 400 of them. Is there a way to make the column automatically add a customer ID, in sequencial order down the column for 434 more customers downward?
View 2 Replies
View Related
Nov 2, 2009
I am trying to create an IF formula so when i try to get the percentage change if lets say the 2008 number was 0 and the 2009 number increased by 9 than i would get an error so i want the if formula to come back as n/a.
View 5 Replies
View Related
Dec 1, 2009
I made a time sheet. In this time sheet i made a macro where when I press ctrl+t it fills in the date in a column and the time in the column next to it. So to start my day I would press ctrl+t and to end it i would goa column over and repeat the macro. and then i made it so that in the fifth column it adds the 2 times together with this formula "=IF(E27>0,(IF(G27>E27, G27-E27, 1+G27-E27)),"")" formula works fine unless you make a "mistake" and change the ending time manually to a time that is early then the starting time but on the same day. So I wanted to see if there is anyway of the total time column can return an error message if the ending time is earlier then the starting time by looking at the date in both date columns. Im going to attach the workbook to this post. on the tabs on the bottom it is under time sheet. and i think the macros should transfer over too. ctrl+t is the time macro if you want to try it out.
I may have not been so clear on explaining it so ask any questions if that is true.
View 13 Replies
View Related
Feb 19, 2013
Is there an easy way to make a new spreadsheet for each tab of a current spreadsheet?
View 3 Replies
View Related
Dec 12, 2007
i have to make a synonym list out of existing wordlist for my professor. As far that’s the most boring job I would like to ask you people, if it could be automatically done by a vba code. I don’t think that that’s technically possible but I hope though that I am wrong and that some one here can help me. I will try my best to describe the problem as good as I can. Please let me know if its not precise.
Here we go!
I have a wordlist containing four columns A,B,C and D. In column A we have got Source Words(sw), in column B word specifications1(ws1), in column C word specifications 2(ws2) and in column D we have many meanings and target words separated by comma (tw1,tw2,tw3,…) for (sw). The interesting columns for our problem are only A containing words (sw) and column D containing meanings and synonyms(tw). The wordlist is supposed be get larger through finding, enhancing and adding synonyms in the same list. The difficult thing would be to make a macro with two modes. In first mode which asks each time before it adds or enhance a cell and in second mode the macro should do all the work alone without asking the user. The existing wordlist looks like: ...
View 41 Replies
View Related
