spreadsheets

Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...

I have three worksheets I'm trying to work from. We will call them Worksheet 1, 2, and 3. I am trying to fill a column in worksheet 1, we will call it "Column B" for accuracy purposes. In order to fill this column, I would like to cross reference the data from Worksheets 2 and 3, and if a...

I am trying to create a spreadsheet that will contain the list of all athletes at our school. Other sheets (Tabs at the bottom) are to have each sport and those athletes that participate in that sport. As I add a new student (athlete) to the master list, I want them to add or delete from the...

Hello! I have a scenario I am trying to solve and I hope this forum can help me. I have 2 spreadsheets with data that I need to compare and flag if a certain fact is found. There would be a table of information on each that looks like this: <tbody> Number Name Amount 1 Louis CK $100,000...

What I am trying to do is have an Excel 2003 spreadsheet (A) where data gets entered, and a summary Excel spreadsheet (B) where I have graphs set up to take the linked data from A and graph it. All of this so that a supervisor can log onto the company network and open spreadsheet B and see...

Can we discuss something regarding Google spreadsheets in this forum:confused:

Hi All, I recently posted a question regarding copying of data from one spreadsheet to another but the spreadsheets I were using were causing problems with their complexity. I have now amended the spreadsheets to try and make the process a little easier. I have one spreadsheet for Site...

In Excel 2007, I am working on a Loan Portfolio Report. The report compares all loans (number, officer, amounts, etc.) each Monday with the same information from the prior week. It is important for me to be able to show which loans are new (not on the prior week's report) and which are gone (on...

My situation is this: I need to report on 5 publications (26 in total) for the different UK local health authorities which I've found to filter by counties. My spreadsheets are divided by members & month, non members, health professionals & agencies. My information is all on different...

I have 4 little daily report and 1 master report; I am trying to link them together so that when someone enters a total on the little report it will change the master report, any advice… <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> thx

Hi everyone, I'm a newbie in using Excel and VBA. I've made this VBAProject that uses a UserForm. The program accepts user inputs from the TextBoxes which are processed then displays the output unto another TextBox. Now I'm planning to improve the functionality of my current VBAProject by...

G'day The following is all in the same workbook (5worksheets) Worksheet 1 'Overview' is made from appending information from all the other 4 user worksheets 'user1, user 2, user 3, user4' Whilst I have been able to append the data using VBA, I need to maintain a link between the spreadsheets...

Ok aqui esta mi problema.. Tengo una lista con nombres de personas.. Y sus correspondientes datos ( direccion, tel,etc..) toda estan en diferentes columnas.. A cada cliente se le ha asignado un Id en la primera columna.. Este archivo no tiene ningun problema.. Pero tengo otro archivo en el cual...

I'm trying to embed an Excel spreadsheet within another spreadsheet. I don't want the dimension of the rows and columns to be the same as the baseline spreadsheet, so I figured I needed to do it this way. I created another Excel file with the table I wanted to embed. I click...

hey guys I'm working with excel and im still new at this. So i have a database and working on a new form, can you guys advice me on how or what code i have to assign to the form so every time i open that workbook the form pops up? i would greatly appreciate it. also what books would you guys...

hey guys im a newby just started programing, i have a basic spreadsheet with following fields: date time make model heres my ? i just want to sum all the cells with the same month, so far i have negative results.... can you guys bail me out? thanks in advance