multiple sheets in excel

Hello Everyone! I got a question to split/copy specific rows of a list to a new sheet. I have try'd searching here on the forums but i coudnt find anything comming close to it. In the sheet they will put an X in a cell with above the numbers 5, 6 or 7. Then the list needs to be copy'd to a new...

Hi, i'm working on a project for our organic feed business, and I've created a spreadsheet for our purchasing corn contracts. Each new contract is another sheet(tab) in the same spreadsheet. I've included a "Totals" sheet as well, that is pulling certain information from each of these...

Hi, I'm trying to set up a spreadsheet of contacts' information with name, country, e-mail address columns and then have the data linked and sorted alphanumerically, by different parameters, on separate work sheet pages. ie Sheet 1 would display the contacts alphabetically by name; Sheet 2...

I'm trying to add a sum function to an attendance tracking workbook. I want the sum to be 5 different totals per person on a monthly basis for one year. Right now, there is a total per person at the end of each month, which is one sheet for each month. I want to pull the total absences...

Hello, I am having a bit of difficulty and need some help with the following I have 3 sheets called Data-2013 Data-2014 Data-2015 These sheets contain weekly performance data for the designated year and the each row holds the same data, i i.e. row 2 = 'widget sales' row 5 = 'sproket sales'...

Good day, I am trying to create an auto-generated log on a new sheet that is based off of data entered from a previous sheet. What I am wanting is when a single cell on the master sheet is modified (in this case a choice is made from a drop down list), a copy of certain cells in that row would...

Good day, I am trying to create an auto-generated log on a new sheet that is based off of data entered from a previous sheet. What I am wanting is when a single cell on the master sheet is modified (in this case a choice is made from a drop down list), a copy of certain cells in that row would...

I apologize if this has already been answered or in the wrong section. I have looked for the answer in many places on the internet, including this website, and haven't found my answer. The intent of the macro is to create a form that will enter in Item details and the state it will be shipped...

I would like to create a Macro that creates a new blank word document, then checks values in a column of cells. The macro will check the value of each cell range, and if the value of the cell is greater than $0.00, it will select a specific worksheet in the workbook that is relevant to that...

I have a basketball stat workbook in Microsoft Excel 2013. There is a tab for each game with the players listed and their stats for that specific game. I also have a tab with the team's stats that pull from each game tab. I would like to be able to add a tab for each player and have their...

Hi, I have been trying to figure this out for several days, hopfully some genius out there can help me. I know I'm close, but just can't get the results I am looking for. Background: I have created 5 report in Access: Have successfully exported them to an Excel Workbook: Now, I am trying to...