What information would an accounting worksheet contain after two businesses merge?
Q. For example, If company A was aquired by Company B after you would record the journal entries to show the transaction, then when you go to create a worksheet to show the financial position of the two companies after the acquisition, what type of information would you include on the worksheet??
Asked by Ashley_LS - Wed Jun 25 15:05:29 2008 - - 1 Answers - 0 Comments
A. One thing would be a type of asset called goodwill. That is the value of the purchase price over the net book value of the assets (or company) that you have purchaed. You will also have the value of the common equity, which would change as a result of the acquisition. If you had done an LBO (leveraged buyout), you would include the new liabilities that were used to finance the purchase of the company. Let me know if this helps.
Answered by pl - Thu Jun 26 22:42:37 2008
Q. For example, If company A was aquired by Company B after you would record the journal entries to show the transaction, then when you go to create a worksheet to show the financial position of the two companies after the acquisition, what type of information would you include on the worksheet??
Asked by Ashley_LS - Wed Jun 25 15:05:29 2008 - - 1 Answers - 0 Comments
A. One thing would be a type of asset called goodwill. That is the value of the purchase price over the net book value of the assets (or company) that you have purchaed. You will also have the value of the common equity, which would change as a result of the acquisition. If you had done an LBO (leveraged buyout), you would include the new liabilities that were used to finance the purchase of the company. Let me know if this helps.
Answered by pl - Thu Jun 26 22:42:37 2008
How do I copy a single excel worksheet onto an additional 50 worksheets?
Q. I have a project that I am working on and I don't want to hit copy and paste a few hundred times. I want to copy a worksheet that I set up onto an additional 50 worksheets in the workbook. I don't need anything filtered, and the additional sheets are already created (blank of course) and named. How the heck do I do this?
Asked by defofangelic - Fri Aug 29 14:15:18 2008 - - 3 Answers - 0 Comments
A. actually you can do this pretty easily by "grouping" your worksheets. first, go to the sheet you want to copy. pressA to select the contents of the entire sheet. now (for the fun part)... click the tab of the first blank sheet. hold down your shift key and then click the tab of the last sheet in your list. You'll notice the tabs turn white (depending on if you've colored your tabs or not). You'll also notice in the excel title bar (blue bar on top) it shows [GROUP]. This means that whatever you do to one sheet in your group, will be done to ALL sheets in that group. so now just "paste" into one sheet, and it gets pasted into every sheet you've grouped. this is also a great method to widen all the same columns/rows, change… [cont.]
Answered by jmorge - Fri Aug 29 14:46:16 2008
Q. I have a project that I am working on and I don't want to hit copy and paste a few hundred times. I want to copy a worksheet that I set up onto an additional 50 worksheets in the workbook. I don't need anything filtered, and the additional sheets are already created (blank of course) and named. How the heck do I do this?
Asked by defofangelic - Fri Aug 29 14:15:18 2008 - - 3 Answers - 0 Comments
A. actually you can do this pretty easily by "grouping" your worksheets. first, go to the sheet you want to copy. press
Answered by jmorge - Fri Aug 29 14:46:16 2008
How do I make excel formulas reference a worksheet in the current workbook?
Q. I am working with a large number of workbooks that contain identical worksheet names. The data (values) in each of these workbooks and worksheets are different, but the formula and data locations are identical on each sheet. I would like to add a new worksheet to each of these workbooks that puts essential information on one sheet in a summary. How can I cut and paste a sheet from one workbook to another and have it reference the book it is in rather than the one I copy it from? Or, must I edit each reference each time I copy it? Thanks in advance.
Asked by Boyd H - Mon Jun 2 18:32:23 2008 - - 1 Answers - 0 Comments
A. Easiest way is probably to copy the sheet, paste it to the new workbook and then user find/replace function to update the workbook references. For example, I you copy this formula from a file called Book1.xls =Sheet1!A1 and paste it into a new workbook, it'll end up looking something like this: =[Book1]Sheet1!A1 If I use the replace function (CNTR + H) and put [Book1] in the "Find what" field and nothing in the "Replace with" field, it will remove the external reference to the other workbook. For the full sheet, do the same thing but hit "Replace All" instead.
Answered by five v - Mon Jun 2 19:59:51 2008
Q. I am working with a large number of workbooks that contain identical worksheet names. The data (values) in each of these workbooks and worksheets are different, but the formula and data locations are identical on each sheet. I would like to add a new worksheet to each of these workbooks that puts essential information on one sheet in a summary. How can I cut and paste a sheet from one workbook to another and have it reference the book it is in rather than the one I copy it from? Or, must I edit each reference each time I copy it? Thanks in advance.
Asked by Boyd H - Mon Jun 2 18:32:23 2008 - - 1 Answers - 0 Comments
A. Easiest way is probably to copy the sheet, paste it to the new workbook and then user find/replace function to update the workbook references. For example, I you copy this formula from a file called Book1.xls =Sheet1!A1 and paste it into a new workbook, it'll end up looking something like this: =[Book1]Sheet1!A1 If I use the replace function (CNTR + H) and put [Book1] in the "Find what" field and nothing in the "Replace with" field, it will remove the external reference to the other workbook. For the full sheet, do the same thing but hit "Replace All" instead.
Answered by five v - Mon Jun 2 19:59:51 2008
How can I jump to an excel worksheet within a workbook?
Q. I have a large Excel workbook. On the first worksheet I list all of my tabs (along with some information). I want to be able to click on a cell (say B1 holds the text Jan) and go to the Jan worksheet in the same workbook.
Asked by vzcowgirl - Sun Jan 13 10:36:25 2008 - - 3 Answers - 0 Comments
A. It's easy enough to do. Highlight the cell that you want to be a link to a different worksheet. Hit Ctrl + K (insert hyperlink). In the "Link to:" section, click on the "Place in this document" button. From here you can set which worksheet to link to. Hope this helps
Answered by SharksRule - Sun Jan 13 10:48:25 2008
Q. I have a large Excel workbook. On the first worksheet I list all of my tabs (along with some information). I want to be able to click on a cell (say B1 holds the text Jan) and go to the Jan worksheet in the same workbook.
Asked by vzcowgirl - Sun Jan 13 10:36:25 2008 - - 3 Answers - 0 Comments
A. It's easy enough to do. Highlight the cell that you want to be a link to a different worksheet. Hit Ctrl + K (insert hyperlink). In the "Link to:" section, click on the "Place in this document" button. From here you can set which worksheet to link to. Hope this helps
Answered by SharksRule - Sun Jan 13 10:48:25 2008
How to copy a worksheet to another workbook without changing cell references?
Q. I want to copy a worksheet from one workbook to another workbook. But the copied worksheet keeps referencing the 1st worksheet. I want it to reference the cell just like it does in the first worksheet. Is there a way to do that? Thanks in advance! Let me indicate I want to copy the worksheet... not the the formulas or the cells. Thanks...
Asked by atl1guy - Tue Sep 15 10:36:31 2009 - - 3 Answers - 0 Comments
Q. I want to copy a worksheet from one workbook to another workbook. But the copied worksheet keeps referencing the 1st worksheet. I want it to reference the cell just like it does in the first worksheet. Is there a way to do that? Thanks in advance! Let me indicate I want to copy the worksheet... not the the formulas or the cells. Thanks...
Asked by atl1guy - Tue Sep 15 10:36:31 2009 - - 3 Answers - 0 Comments
What steps do you take to protect individual cells and not the entire worksheet in excel?
Q. I can protect the entire worksheet but not individual cells.
Asked by wondering - Thu Apr 2 11:39:52 2009 - - 2 Answers - 0 Comments
A. If you want to have only certain cells protected on a worksheet, to prevent loss of formulas, etc, you CAN do it by protecting the entire worksheet. By default, Excel sets each cell to 'Locked'. So, if you protect the entire sheet every cell is protected. To protect only certain cells, select cell A1 through and including the cell used in the last column and row on that sheet. For example, A1 thru O30. Then go to Format > Cells > Protection and uncheck the 'Locked' checkbox. Click 'OK'. Next, hold the Ctrl key down and click on each cell you want to protect. Go to Format > Cells > Protection and click the 'Locked' checkbox. If you don't want users to see your formulas, make sure the 'Hidden' check box is ticked. Click 'OK [cont.]
Answered by garbo7441 - Thu Apr 2 12:14:52 2009
Q. I can protect the entire worksheet but not individual cells.
Asked by wondering - Thu Apr 2 11:39:52 2009 - - 2 Answers - 0 Comments
A. If you want to have only certain cells protected on a worksheet, to prevent loss of formulas, etc, you CAN do it by protecting the entire worksheet. By default, Excel sets each cell to 'Locked'. So, if you protect the entire sheet every cell is protected. To protect only certain cells, select cell A1 through and including the cell used in the last column and row on that sheet. For example, A1 thru O30. Then go to Format > Cells > Protection and uncheck the 'Locked' checkbox. Click 'OK'. Next, hold the Ctrl key down and click on each cell you want to protect. Go to Format > Cells > Protection and click the 'Locked' checkbox. If you don't want users to see your formulas, make sure the 'Hidden' check box is ticked. Click 'OK [cont.]
Answered by garbo7441 - Thu Apr 2 12:14:52 2009
Is the macro recorded in a worksheet only applicable to that particular worksheet?
Q. I have recorded a marco using excel 2003 in a worksheet, I am trying to run the macro in the other sheets of the workbook and it's not working. Can't this be done, if yes, can someone enlighten me please?
Asked by KC - Wed Jul 9 10:43:33 2008 - - 1 Answers - 0 Comments
A. Yes, you can use the recorded macro on other sheet, however right after you click ok to start the recording, you have to click the relative reference button in on the stop recording panel to have that started. If you can see the stop recording panel, right click on the menu toolbar and choose customize, toolbar tab, on the list, check box next to stop recording.
Answered by AQuestionMark - Wed Jul 9 21:48:26 2008
Q. I have recorded a marco using excel 2003 in a worksheet, I am trying to run the macro in the other sheets of the workbook and it's not working. Can't this be done, if yes, can someone enlighten me please?
Asked by KC - Wed Jul 9 10:43:33 2008 - - 1 Answers - 0 Comments
A. Yes, you can use the recorded macro on other sheet, however right after you click ok to start the recording, you have to click the relative reference button in on the stop recording panel to have that started. If you can see the stop recording panel, right click on the menu toolbar and choose customize, toolbar tab, on the list, check box next to stop recording.
Answered by AQuestionMark - Wed Jul 9 21:48:26 2008
How can I unprotect an Excel worksheet without the password?
Q. I need to modify a document in Excel but lost the password that is required to unprotect the worksheet so I can edit it. Is there any way to override the protection or at least copy and paste all the contents into a new blank worksheet? It will not allow me to copy any part of the worksheet whatsoever.
Asked by saraalyson06 - Thu Feb 5 20:36:03 2009 - - 2 Answers - 0 Comments
A. One way I open the protected sheets (And password forgotten) is to copy entire sheet and paste the entire sheet in a new sheet or new workbook. This generally works
Answered by enLightened1 - Sun Feb 8 11:25:02 2009
Q. I need to modify a document in Excel but lost the password that is required to unprotect the worksheet so I can edit it. Is there any way to override the protection or at least copy and paste all the contents into a new blank worksheet? It will not allow me to copy any part of the worksheet whatsoever.
Asked by saraalyson06 - Thu Feb 5 20:36:03 2009 - - 2 Answers - 0 Comments
A. One way I open the protected sheets (And password forgotten) is to copy entire sheet and paste the entire sheet in a new sheet or new workbook. This generally works
Answered by enLightened1 - Sun Feb 8 11:25:02 2009
How do I change the axis of multiple charts in an Excel Worksheet?
Q. I have dozens of charts in one worksheet and I want to change the x and y axis so that they are all standard.. Is it possible to change them all at once or so you have to do one at a time?
Asked by ames81 - Tue Aug 25 03:07:31 2009 - - 1 Answers - 0 Comments
A. You're pretty much stuck doing them one at a time. If you know how to program in VBA, it is possible to do them all at once. It's all a matter of how many you have to do. If it's <10, you'll use up less time reformatting each one individually. If you have a lot more than 10, it might be worth it to search the web for VBA code examples others have written to reformat charts en masse.
Answered by I_dun_doodit - Wed Aug 26 14:28:31 2009
Q. I have dozens of charts in one worksheet and I want to change the x and y axis so that they are all standard.. Is it possible to change them all at once or so you have to do one at a time?
Asked by ames81 - Tue Aug 25 03:07:31 2009 - - 1 Answers - 0 Comments
A. You're pretty much stuck doing them one at a time. If you know how to program in VBA, it is possible to do them all at once. It's all a matter of how many you have to do. If it's <10, you'll use up less time reformatting each one individually. If you have a lot more than 10, it might be worth it to search the web for VBA code examples others have written to reformat charts en masse.
Answered by I_dun_doodit - Wed Aug 26 14:28:31 2009
How to link a cell to more than one cell in MS excel worksheet ?
Q. I want to display merging 3 different data of 3 different cells in a one cell of different worksheet. How can I link it by formula ? can anybody help me ?
Asked by abc - Wed Jun 10 23:29:45 2009 - - 2 Answers - 0 Comments
A. Since I am not quite sure exactly what you mean by your question and explanation, I will give you two different ways to handle such things: The first one is where one worksheet has different columns (A thru C) for a person's name: FirstName, MiddleName, LastName. In the second worksheet, the formula would look something like the following: = Sheet1! A1 & IF(ISBLANK(B1),""," " & B1) & IF(ISBLANK(C1),""," " & C1) This will combine text values into a single value of one cell when entered in Sheet2. The second one is where one worksheet has different columns (A thru E) of numeric values. = SUM(Sheet1!A1:E1) This will calculate all of the referenced cells and show the total value in Sheet2.
Answered by unknown - Fri Jun 12 22:52:07 2009
Q. I want to display merging 3 different data of 3 different cells in a one cell of different worksheet. How can I link it by formula ? can anybody help me ?
Asked by abc - Wed Jun 10 23:29:45 2009 - - 2 Answers - 0 Comments
A. Since I am not quite sure exactly what you mean by your question and explanation, I will give you two different ways to handle such things: The first one is where one worksheet has different columns (A thru C) for a person's name: FirstName, MiddleName, LastName. In the second worksheet, the formula would look something like the following: = Sheet1! A1 & IF(ISBLANK(B1),""," " & B1) & IF(ISBLANK(C1),""," " & C1) This will combine text values into a single value of one cell when entered in Sheet2. The second one is where one worksheet has different columns (A thru E) of numeric values. = SUM(Sheet1!A1:E1) This will calculate all of the referenced cells and show the total value in Sheet2.
Answered by unknown - Fri Jun 12 22:52:07 2009
How can I copy the contents of a cell from one worksheet to another?
Q. I would like to know how I can copy the cell from one sheet to another by using a formula but it doesn't seem to work. The original worksheet has a formula but I want it to be copied to another worksheet. I tried copy-paste but it still doesn't work. It copies the ranges on the original worksheet.
Asked by aoshi_0514 - Fri Apr 7 15:33:47 2006 - - 5 Answers - 0 Comments
A. If you a trying to link multiple worksheets instead of just copying... Go to where you want the formula to be, say on worksheet 2 cell A1, and type "=" then go to the cell you want to copy, say in workseet 1 cell B1. (Click on worksheet one and click in cell B1) It should get outlined in blue or green or something like that, then hit enter. Now cell A1 in workseet 2 should contain the formula "=B1" from worksheet 1. Basically you are telling Excel that cell A1 on sheet 2 equals whatever # or formula is in cell B1 on sheet 1. Does that make sense? Its not hard. Just hard for me to explain.
Answered by trying2bhelpful - Fri Apr 7 15:39:46 2006
Q. I would like to know how I can copy the cell from one sheet to another by using a formula but it doesn't seem to work. The original worksheet has a formula but I want it to be copied to another worksheet. I tried copy-paste but it still doesn't work. It copies the ranges on the original worksheet.
Asked by aoshi_0514 - Fri Apr 7 15:33:47 2006 - - 5 Answers - 0 Comments
A. If you a trying to link multiple worksheets instead of just copying... Go to where you want the formula to be, say on worksheet 2 cell A1, and type "=" then go to the cell you want to copy, say in workseet 1 cell B1. (Click on worksheet one and click in cell B1) It should get outlined in blue or green or something like that, then hit enter. Now cell A1 in workseet 2 should contain the formula "=B1" from worksheet 1. Basically you are telling Excel that cell A1 on sheet 2 equals whatever # or formula is in cell B1 on sheet 1. Does that make sense? Its not hard. Just hard for me to explain.
Answered by trying2bhelpful - Fri Apr 7 15:39:46 2006
What formula do you use for Microsoft Excel that references info on the 1st worksheet from a 2nd worksheet?
Q. I have to research a way to create a formula using Microsoft Excel and it has to do with referencing information on one worksheet from a second worksheet. Can anyone help me? All I need is the formula to do this referencing. I searched all over, but couldn't find anything on referencing. Please help! Thank you in advance!
Asked by mp - Fri Aug 15 21:58:38 2008 - - 3 Answers - 0 Comments
A. To reference another cell, or link to a cell: =A1 To link to a cell in another sheet: ='Sheet1'!A1 To link to a cell on another workbook: ='[book1.xls]Sheet1'!A1
Answered by Sarah M - Sat Aug 16 21:09:26 2008
Q. I have to research a way to create a formula using Microsoft Excel and it has to do with referencing information on one worksheet from a second worksheet. Can anyone help me? All I need is the formula to do this referencing. I searched all over, but couldn't find anything on referencing. Please help! Thank you in advance!
Asked by mp - Fri Aug 15 21:58:38 2008 - - 3 Answers - 0 Comments
A. To reference another cell, or link to a cell: =A1 To link to a cell in another sheet: ='Sheet1'!A1 To link to a cell on another workbook: ='[book1.xls]Sheet1'!A1
Answered by Sarah M - Sat Aug 16 21:09:26 2008
When copying an entire Excel worksheet to a new one, how do you retain the macros in the new worksheet?
Q. Every time I copy a worksheet, I have to go back and copy the macros from the old worksheet to the new worksheet and then link everything back up... is that necessary?
Asked by feelthenails - Thu Jan 31 09:24:19 2008 - - 3 Answers - 0 Comments
A. Rachel's way is a pretty good way of doing it. However, there is an easier way if you are writing macros or if you are copying the sheets a bunch to new workbooks. Instead of putting your coding in a regular module, put the code inside of the worksheet. Go to Visual Basic Explorer by pressing Alt + F11 while in Excel. Then go to the Project Window in the top left corner and double-click on the worksheet in your workbook where you want to have the code. Then just paste the code from your module into that worksheet's code window. Should work and copy over whenever you need to copy the worksheet. So you do the operation once and don't have to drag or save the file as something else and delete each time. Do it once and you're done.
Answered by devilishblueyes - Fri Feb 1 07:24:46 2008
Q. Every time I copy a worksheet, I have to go back and copy the macros from the old worksheet to the new worksheet and then link everything back up... is that necessary?
Asked by feelthenails - Thu Jan 31 09:24:19 2008 - - 3 Answers - 0 Comments
A. Rachel's way is a pretty good way of doing it. However, there is an easier way if you are writing macros or if you are copying the sheets a bunch to new workbooks. Instead of putting your coding in a regular module, put the code inside of the worksheet. Go to Visual Basic Explorer by pressing Alt + F11 while in Excel. Then go to the Project Window in the top left corner and double-click on the worksheet in your workbook where you want to have the code. Then just paste the code from your module into that worksheet's code window. Should work and copy over whenever you need to copy the worksheet. So you do the operation once and don't have to drag or save the file as something else and delete each time. Do it once and you're done.
Answered by devilishblueyes - Fri Feb 1 07:24:46 2008
How do I filter excel data from one Master worksheet into a different worksheet?
Q. I have a Master list of conferences for different clients. I would like this data to filter into a different worksheet (same excel file) for each client seperately. I tried Advanced filter and had no luck. Each client has their own tab/worksheet. I dont want to have to copy and paste - I would like excel to grab the lines of data where the client is mentioned and filter it onto their seperate sheet. any help woudl be appreciated!!
Asked by jennadeangelis - Fri Jan 4 23:45:38 2008 - - 1 Answers - 0 Comments
A. type "=(sheetname)!(cell) =Sheet1!B6 You will then be able to click and drag bottom right corner of cell to "copy formula" and it will extend like.. =Sheet1!B7... =Sheet1!B8... etc Good luck
Answered by jimbobjrbob - Fri Jan 4 23:49:43 2008
Q. I have a Master list of conferences for different clients. I would like this data to filter into a different worksheet (same excel file) for each client seperately. I tried Advanced filter and had no luck. Each client has their own tab/worksheet. I dont want to have to copy and paste - I would like excel to grab the lines of data where the client is mentioned and filter it onto their seperate sheet. any help woudl be appreciated!!
Asked by jennadeangelis - Fri Jan 4 23:45:38 2008 - - 1 Answers - 0 Comments
A. type "=(sheetname)!(cell) =Sheet1!B6 You will then be able to click and drag bottom right corner of cell to "copy formula" and it will extend like.. =Sheet1!B7... =Sheet1!B8... etc Good luck
Answered by jimbobjrbob - Fri Jan 4 23:49:43 2008
I have been receiving unemployment checks and found a job. How do I fill out the worksheet now to notify?
Q. I have been getting unemployment checks. I have my worksheet and want to know how I need to fill it out to stop unemployment benefits starting the week where I begin working full-time.
Asked by curious girl - Mon Mar 9 13:30:26 2009 - - 4 Answers - 0 Comments
A. The best way would to call your local unemployment office and explain your situation. Most likely they will have you fill out form to sign or just stop their payment. Either way, you won't lose anything... Congrats on getting a job!
Answered by Anna K. P - Tue Mar 10 17:32:23 2009
Q. I have been getting unemployment checks. I have my worksheet and want to know how I need to fill it out to stop unemployment benefits starting the week where I begin working full-time.
Asked by curious girl - Mon Mar 9 13:30:26 2009 - - 4 Answers - 0 Comments
A. The best way would to call your local unemployment office and explain your situation. Most likely they will have you fill out form to sign or just stop their payment. Either way, you won't lose anything... Congrats on getting a job!
Answered by Anna K. P - Tue Mar 10 17:32:23 2009
How do I repeat rows on each page of a worksheet in Excel?
Q. I need to insert the same data from two rows on all pages of a worksheet, and not in the footer, at the bottom of a table on mutliple pages. I do not know how to do this...any help would be appreciated!
Asked by Karen S - Mon Apr 27 12:29:17 2009 - - 2 Answers - 0 Comments
A. If you are trying to get 'rows to repeat at the bottom of the page' in Excel, that cannot be done in Excel. It might be possible to do it with a VBA macro. Of course, as you are probably aware, there is a way to get rows to repeat at th top of the page. File > Page Setup and select the Sheet tab. Under Print Titles > Rows to repeat at top enter the rows to repeat. For rows 1 and 2, enter $1:$2
Answered by garbo7441 - Mon Apr 27 17:02:46 2009
Q. I need to insert the same data from two rows on all pages of a worksheet, and not in the footer, at the bottom of a table on mutliple pages. I do not know how to do this...any help would be appreciated!
Asked by Karen S - Mon Apr 27 12:29:17 2009 - - 2 Answers - 0 Comments
A. If you are trying to get 'rows to repeat at the bottom of the page' in Excel, that cannot be done in Excel. It might be possible to do it with a VBA macro. Of course, as you are probably aware, there is a way to get rows to repeat at th top of the page. File > Page Setup and select the Sheet tab. Under Print Titles > Rows to repeat at top enter the rows to repeat. For rows 1 and 2, enter $1:$2
Answered by garbo7441 - Mon Apr 27 17:02:46 2009
What is the method for creating an excel formula that references information from one worksheet to another?
Q. What is the formula to reference information from one excel worksheet to another excel worksheet?
Asked by g s - Sat Mar 8 10:59:21 2008 - - 1 Answers - 0 Comments
A. 1) In the cell you want to display the information press =. 2) Click on the sheet with the informaiton you want to reference. 3) click on it. or 1) Copy the cell with the info you wish to reference to. 2) Go to the cell you want the formula linked to. 3) Right click and choose paste special. 4) Choose 'Paste Link' or If you want the formula, its: =Sheet2!A1 This references to cell reference A1 on sheet 2. Did you mean worksheets or workbooks by the way?
Answered by Kori - Sat Mar 8 11:10:33 2008
Q. What is the formula to reference information from one excel worksheet to another excel worksheet?
Asked by g s - Sat Mar 8 10:59:21 2008 - - 1 Answers - 0 Comments
A. 1) In the cell you want to display the information press =. 2) Click on the sheet with the informaiton you want to reference. 3) click on it. or 1) Copy the cell with the info you wish to reference to. 2) Go to the cell you want the formula linked to. 3) Right click and choose paste special. 4) Choose 'Paste Link' or If you want the formula, its: =Sheet2!A1 This references to cell reference A1 on sheet 2. Did you mean worksheets or workbooks by the way?
Answered by Kori - Sat Mar 8 11:10:33 2008
How do I get information off a webpage and feed it into my Excel worksheet daily?
Q. I'm trying to get information off a website and feed it into my excel worksheet, then take certain information off my excel worksheet (for example: F3..I3) and incorporate it into my webpage.
Asked by Inquirer - Mon Jan 15 04:23:55 2007 - - 1 Answers - 0 Comments
A. Well, you can feed a web page directly to a excel sheet: Go to "Data", then "Import External Data", then "new web query". Use the link to go to the web page you want to download info from, then checkmark the arrows to select the areas of that web page you want, and finally click "import". Tell Excel where you want the import to go. Then it will import the data directly into Excel. You can then play with the information there. If your website updates, instead of doing it all over again, all you now have to do is have your cursor in that section you just imported, and click on the "!" (or data --> refresh data) button and it will re-import that web page section. Not sure that you can update your web page in reverse, though. Hope that… [cont.]
Answered by Moondog - Mon Jan 15 11:37:15 2007
Q. I'm trying to get information off a website and feed it into my excel worksheet, then take certain information off my excel worksheet (for example: F3..I3) and incorporate it into my webpage.
Asked by Inquirer - Mon Jan 15 04:23:55 2007 - - 1 Answers - 0 Comments
A. Well, you can feed a web page directly to a excel sheet: Go to "Data", then "Import External Data", then "new web query". Use the link to go to the web page you want to download info from, then checkmark the arrows to select the areas of that web page you want, and finally click "import". Tell Excel where you want the import to go. Then it will import the data directly into Excel. You can then play with the information there. If your website updates, instead of doing it all over again, all you now have to do is have your cursor in that section you just imported, and click on the "!" (or data --> refresh data) button and it will re-import that web page section. Not sure that you can update your web page in reverse, though. Hope that… [cont.]
Answered by Moondog - Mon Jan 15 11:37:15 2007
How to ensure the copied worksheet (excel) also change according to the original?
Q. The original worksheet has a lot of formulas and if it is changing, i would like the copied worksheet also change accordingly.
Asked by effa - Thu Sep 13 21:25:35 2007 - - 2 Answers - 0 Comments
A. I am not sure how you have copied it.. But you have to make a link between the 2 sheets. One method is to copy the original sheet and then Go to other sheet Paste Special Select "Paste Link"
Answered by Chaminda - Fri Sep 14 21:25:56 2007
Q. The original worksheet has a lot of formulas and if it is changing, i would like the copied worksheet also change accordingly.
Asked by effa - Thu Sep 13 21:25:35 2007 - - 2 Answers - 0 Comments
A. I am not sure how you have copied it.. But you have to make a link between the 2 sheets. One method is to copy the original sheet and then Go to other sheet Paste Special Select "Paste Link"
Answered by Chaminda - Fri Sep 14 21:25:56 2007
Can you format a worksheet in currency in excel 2007?
Q. I'm learning how to use excel and I'm trying to figure how to format a worksheet in currency.
Asked by generous - Fri Nov 14 19:35:21 2008 - - 2 Answers - 0 Comments
A. Select the cells you want to be in currency format, right click, format cells, click currency, click OK.
Answered by unknown - Fri Nov 14 19:39:26 2008
Q. I'm learning how to use excel and I'm trying to figure how to format a worksheet in currency.
Asked by generous - Fri Nov 14 19:35:21 2008 - - 2 Answers - 0 Comments
A. Select the cells you want to be in currency format, right click, format cells, click currency, click OK.
Answered by unknown - Fri Nov 14 19:39:26 2008
From Yahoo Answer Search: 'worksheet'
Tue Nov 17 21:41:14 2009 [ refresh local cache ]
[Hide]▼
news.google.com
Alexandria Echo Press
Questions on that worksheet included, How did President Obama inspire me and What can I do to help the president. Since this was sent out before a copy ...
edmodo.com
Mr. Koch
ue, 10 Nov 2009 17:25:05 GM
Worksheet. - 8.3.2 Identify IP Address Classes (25pts)
[Hide]▲
