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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.