Recent content by FlixMixIntern

Columns b,c,d,etc are completely different from sheet1.

That is correct, it does sort the columns that I am mirroring, but it does not sort the other columns in the worksheet. What I'd like to know is how to sort those other columns. Thanks.

I have an Excel file with two sheets. One column in Sheet2 pulls data from Sheet1 using a formula like this... =Sheet1!A1 I am having a problem with sorting. I can easily sort Sheet1 using the sort option, but I also want to be able to simultaneously sort the corresponding data in Sheet2...

I see, if I copy and paste this formula, it will alter it for me. Now, another question... In each cell on the new sheet that has no corresponding data from the first sheet, a "0" is printed. How can I alter the formula so that it will not put in this number? Thanks. Cameron...

yes, but I have something like 100 cells in this column. Will I need to edit this forumula for each cell, so it would look something like this... =Sheet1!A1 =Sheet1!A2 =Sheet1!A3 =Sheet1!A4 and so on. Or, could I just use a wizard that will save me a whole bunch of time. Thanks. Cameron...

Hi, Here is what I would like to do. Can anyone help me? On sheet1 of my Excel file, I have a column called "Title". What I would like to do is punch in a formula on sheet4 that will copy the entire contents of the column from sheet1 and paste it on sheet4. I thought I should...

Hi, I've got two questions regarding an Excel file I have which has data on two sheets. 1) On sheet one, I have the company name as one of my columns. Can I set up sheet two in such a way that it has the same column, but the cells are uneditable and gets the info from the first sheet? 2)...

Hi, I have an Excel file, which has data spread out over 3 seperate "sheets". What I want to do is set up a mail merge in Word that will allow me to pull certain data from each sheet. But, when I set up the mail merge, it will only pull data from Sheet 1. How can I set up the merge...