talk

Hello all, I'm wondering if it's possible to make 2 separate excel workbooks to talk to one another. For instance if I have a credit card receipt in one workbook and a separate workbook for projects- am I able to make the first spreadsheet talk to the second spreadsheet and add in the correct...

For the formula below, can you talk out what the formula is saying for that cell =IFERROR(UPPER(INDEX(Range_Desc,MATCH(ROW()-ROW($A$10),Range_Valid,0))),"")

I have an Excel Table named "TalkNames" as follows, the full table contains 194 talks listed: <tbody> Talk Number Talk Title 1 AAAA 2 BBBB 3 CCCC </tbody> A second table is a database of when each talk is given, where and by whom. I then extract the data from this database...

I have two workbooks that are communicating with each other, One workbook is used by a clerk and has data entered intoit, the other work book is displayed on a monitor outside of the office. I am trying to get the two workbooks to talk to each otherso the clerk doesn’t have to pull the display...

Would really like to talk to someone about how to approach a problem. I have tried everything I could think up. I have looked online and even asked friends. I have wasted a lot of time trying to figure this out and would just like to see if anyone really good with excel might want to talk and...

Dear Reader, How I can write VBA program - I am beginner. I had created an excel sheet with two sheets "Sheet 1 for filling reporting the data" "Sheet 2 for counting the filled or reported data". I had used following formula - =COUNTIFS('EHS Walk & Talk Report Status'!B2:B1000,"W1",'EHS Walk...

or a contact center, I have a Tableau sheet with rows showing employee name, type of call, number of calls, and avg talk time. I want to be able to show the total group avg talk time by type of call. I've tried just showing grand totals (avgs), but that just gives me one final number, while...