Get instant free expert help with Excel and Google Sheets

i need to separate out rows that contain a subtotal calculation from other rows

I want to copy a page of a sheet into a new worksheet. The page which I am trying to copy has query tables from another worksheet in the workbook. So when I copy the page into a new sheet, the tables and graphs produced from these tables do not contain the query tables. So in short my question is, How can I copy the page of a sheet which has query tables into a new worksheet without losing the query tables?

I am compiling data sets for countries. I only want to include countries that have data for two variables (literacy rates & GDP). One of the data sets do no include certain countries. I want a formula that will delete the country and its data, if said country does not appear in the other data set.

I am using Excel 2011. One 'column' of cells I created in my spreadsheet contains text that is 'wrapped' anywhere between 1 to 10 lines. The data in all cells is displayed in the worksheet as entered. But, some of the cells, not all, display in 'print preview' and on the 'printout' only a portion of the data in a format I selected. (ie: six lines of text in one cell appear as two and are cut-off to the right in preview and on the printout - while another cell containing ten lines of text previews and prints correctly) The format for all these cells is 'exactly' the same. I have changed font styles/sizes, column width/height, page layout, etc, etc, and the results are always the same. Please tell me what I need to do to correct this problem. EXAMPLE: Cell "C-7" contains 6 lines of text. But, only 2 (partial) lines of text appear in the 'print preview' window and on the 'printout'.

I need to duplicate the same rows on another sheet when new rows are added. Repeat session for Expert_777

I'm typing text into B2 but i want the column to expand to fit all text in the one column not spread across the the next columns

I want to use conditional formatting using the New Rule> Use a formula to determine... The company is in column A. In the columns R to AB are locations where there may or may not be offices of the company in A. If there is an office, it is marked with a '1'. No office is a blank field. I want to highlight in green (column A) any companies where there are three or more office locations noted in R to AB. It should be applied to the whole workbook.

Need data reformatted - First tab contains all raw data . Second tab shows example of how I'd like data to look like. The first tab is the employee's full history - hire in information on one line - termination on a seperate line. I'd like this info set up columnar. As you can see, some employees have more than one period of employment, so I want those to be entered in the additional columns in tab 2. The home department and hire date should come from the "Position Status" active line. The termination date is the only info that comes from the "Position Status" terminated line.

Hello, I need to know how to assign data to a macro buttons so that when clicked, data from another sheet automatically populates on the sheet the macro button is on.

1)Creating a cell that has dependent data validation from a category list 2) vlookup or if statement, that when a category and then a description has been selected from drop downs, a unit price will automatically appear