spreadsheets

Hi everyone. I need some help creating a spreadsheet to calculate revenue from different businesses, and I want to keep all the data separate. But, I also want the data to interact with each other on one master sheet. There is also data that is the same across spreadsheets that it would be...

Our working papers from year to year are named the same thing for ease of use. In the past we had a short script that added a "right click and open separately." The older script does not work with 365. We have searched the internet to see if there is something out there for 365 but so far no...

I need to compare 2 spreadsheets and identify the employees missing from one of them. The first spreadsheet is a list of our employees. The second spreadsheet is a list of employees that attended a training in October 2017. Both spreadsheets include the employees unique badge number. Can I use...

I am trying to complie a number of spreadsheets containing dates of appointments, unfortunately one of the spreadsheets the person has enter the date as 3rd Dec 2016 instead of 03/12/16. How can i convert it please. thank you in advance.

I am looking to use a macro to copy and paste information stored across multiple spreadsheets, in the same work book in to a specific sheet in specific locations on that sheet. This will then need to move on to another sheet into the workbook and copy and paste a different array of information...

I have tried to find a forum response that fits my particular scenario, and I have found similar ones but not quite what I need. I have two different spreadsheets which I would like to compare two pieces of criteria and only if BOTH criteria are met, then I would like cells in a particular...

I have two spreadsheets: 2017-08-03 Compliance Response and Current Compliance. Both spreadsheets have the same column and column headers. 2017-08-03 COMPLIANCE RESPONSE/NJN Tab - I need to add the data from column K using column L as my lookup value to column H of the "CURRENT COMPLIANCE"...

Hi All, I need to mirror two spreadsheets exactly including the colors. One thing I need to ensure is that new rows are also added to the second spreadsheet. Here is the formula I currently have, what am I missing...

Hello, I am trying to create a macro which copies and pastes the last 3 Spreadsheets of a Workbook into a new one. Anyone has any ideas of how this can be accomplished? What I've tried so far does not work. Thank you in advance!

Hi All, I have got two spreadsheets with various columns in them. One column in both spreadsheets has cells which contains one or more words and numbers. The first spread has about 160 rows and the second spreadsheet has quite a lot more. What I would like if possible is, if one word and or...

I use several Excel spreadsheets. I am running WIN 10. About a week ago, all of my Excel spreadsheets opened in READ ONLY format, including archived documents, new documents, and templates that I re-use frequently. I tried re-naming, save as, changing settings, etc., and other suggestions...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I have a 2 large spreadsheets that contain different pieces of information. In both spreadsheets column A (Project ID) is the common identifier. In some cases there is only one...

I realize this is a bit of a tricky question so I am going to attempt to break it down piece by piece, I have been working on a tool to automate the formatting of our monthly budget revisions into our report style. The macro essentially copies a large spreadsheet (A-Z, with about 500 rows but...

Hello! I am very very new to Excel and need assistance with transferring data from on sheet to another....please be patient with me :) In a nutshell, I need to have 3 columns of data from 4 separate spreadsheets automatically transfer to another "master" spreadsheet. The data contains "Date"...

Dear All, I have a large number of Spreadsheets contained in a Workbook Approximately four Spreadsheets are linked to all the others using formulae. What I would like to know is what is the best\easiest way to link all these Spreadsheets rather than inputting each individual formula manually...

I have a Spreadsheet with over one-million rows of data. Of course it takes awhile to load or even update. Plus when I try to run a filter it vegetates every time. I was wondering if there are things I can do (e.g. save in older formats, remove "bells and whistles" or formatting) that would...

I have been emailed a large number of Word documents which contain a large number of tables. I have been asked to put the data onto an Excel Spreadsheet so that some analysis can take place. Each Word document contains 7 tables. However, the tables vary in number of rows and columns...

I'd like a spin button that is accessible no matter what spreadsheet (tab) I'm in. The button will be used to match columns of data with another column of data. The reason I'm trying to do this is because I cannot seem to find out how to match two columns of data... I need to match data with...

This one is a complicated question. I have several spreadsheets that are added to, subtracted from, and changed daily. These spreadsheets list the location and information of various tissue samples - I work in the medical field. There are two types. Type A: The pre-existing spreadsheets...

2014 ModelOff New York Live Finals (FREE) If you’re in New York City this Sunday, join leaders from the Finance and Excel communities to witness the crowning of a new Financial Modeling World Champion. Who will follow in the footsteps of Alex Gordon and Hilary Smart and claim the $30,000USD...