spreadsheet

I came across someone in the office today that has been spending huge amounts of time on unnecessary copy/paste/sort gymnastics and it hurt my soul to watch. I know you geniuses can help me/her out so here's what she's doing... She's working with 3 spreadsheets; I'll call them Initial...

Hi! I have a spreadsheet with data from a survey: 9 questions, each with an answer between 1 and 5. I have a pivot table that shows me a breakdown of how many of each answer (1 through 5) there is for a single question. Is there a way that I can include all of my data and filter by question, so...

I am looking for a formula to help me in my spreadsheet. I want it to look for the month of January and an ID# with the amounts in that row to copy it into the next 11 months. So January would be column B and ID# in Column E, while the data i want to copy are in J, K, and L. It should display...

Hi I've inherited a spreadsheet which has the following formula in it =HLOOKUP($AZ$3,$C$13:$P$53,@MATCH(C16,$C$15:$C$53,0)+2,FALSE) I'm happy with how it works but I've never seen the @MATCH phrase before, how does this differ from a straight MATCH statement ? I've tried deleting the @ and...

I currently have a spreadsheet that is filled with functions and. using macros. loops through thousands of potential combinations searching for the best possible solution. This is all being done to try and match up tennis players who have competed the least amount of times against one...

Hi, I am looking to automatically generate a unique identification number for each row in my spreadsheet. A few components of the number will be passed into the spreadsheet from another source. But, I need help creating two different parts of the ID. The first is a 3 digit number that will...

Hi all, I have a macro enabled spreadsheet that has multiple auto-complete drop-down lists. When the file is shared the drop-down list did not appear from the selected cell but instead appeared in another cell (see screenshot from the link below). I have also attached the spreadsheet if someone...

Hello, hoping this is an easy solve for you guys! I have a spreadsheet where I need to regularly copy the bottom half of it to a new spreadsheet while leaving the top half's data behind. The sections are separated by a row of cells with the green color (5296274). I am thinking this should be an...

We have a macro that reviews all the formatting of one spreadsheet against another spreadsheet. My problem: If spreadsheet "A" has a percentage formatting of 0.00% and spreadsheet "B" has a percentage formatting of 0.000%, when entering the results in a separate "Results" spreadsheet, Excel...

Hello I have a VBA in a spreadsheet so that all data i enter aligns to the top and left. However when I copy over data from another spreadsheet it seems to override the vba formatting any ideas? Thank you. Sub Stuff() Dim wks As Worksheet For Each wks In Worksheets...

Hi, I have a database of different company names and their respective stock symbols (spreadsheet 1) and in another spreadsheet I have company name and descriptions (spreadsheet 2) that aren't exactly written the same way as they are in my initial database. I would like to try to use some parts...

Hello I wnat to be able to copy and paste from one spreadsheet to another without changing column widths. For example. Spreadsheet 1 is set up with the widths of the colums i need. The other excel Spreadsheet2 I need to copy out the data from this into spreadsheet1 but im colums go back to...

Hi i would like to design a spreadsheet with my staff in the first column and time across the spreadsheet. A coloured bar across the weeks would show when that staff member was available. The bar would be blank when they were on leave. This would visualise the numbers of staff numbers available...

Through intellisense, I cannot find the backcolor fill setting for a checkbox shape within an Excel spreadsheet. I've used the "With" statement to make sure I'm selecting the one-and-only checkbox on the spreadsheet as well as the entire workbook. I'm not sure why this doesn't work? With...

i am sent a spreadsheet each day of performance. I have a recorded macro that deletes all the data not relevant to me which leaves me with 5 rows/10 columns of data. The columns are constant each day. I would like the macro to proceed in copying that days data onto a separate master spreadsheet...

Hello everyone. I'm running Windows 10 and Office 365. I'm looking for a formula or formulas to automate my spreadsheet. Right now this is what I have. Book1ABCDEFGHIJKLMNO11234529/1911022282940200My data is in cells A1:F250.39/1861011162540200Numbers in row 1 goes from...

Hi all I'm about to have a genuine emotional breakdown over a spreadsheet I've created for work and I'm really hoping someone can help me work out wth is going on and how to fix issues I'm having please. In short, I work at a training company and have created a spreadsheet with multiple...

Dear members of the forum, I'm struggling with a mind-numbing task that needs immediate automation. While we're looking for cheap alternatives to employ for automating kilometer calculation from point A to point B, I thought it's best to inquire the forum what are the possible options to 1)...

Hi, If this isn't appropriate, please forgive me and let me know. I have a small business and am looking for a simple solution to taking inventory at the end of my season. I would like to be able to scan barcodes to enter the info. I would also like to be able to scan an item 3 times, for...

Have an odd problem when using excel in my computer. Everytime I try to update a cell in a spreadsheet that is already connected to another one, I being asked to find the file again and link it for every cell, this means that I need to go one by one selecting the file, rather than doing it...