| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Spreadsheets without referencing other workbook.
I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references Workbook A in the formulas. Is there any way to copy a sheet without this happening? example: formulas look like =[WorkbookA.xls]Data!D11 - I don't want the [WorkbookA.xls] included after copying, it should just read Data!D11. There is already a sheet in the new workbook titled Data that I would like it to point to. Any help would be greatly appreciated! Matt |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Spreadsheets without referencing other workbook.
Hi Matt,
If what I exactly understood by your question. Do not copy from where the name of the worksheet appears. Select all (Crtl+A) the Worksheet A and Copy all the cells. Open Worksheet B. Right click your mouse button at A1 of the Worksheet B and click Paste Special and select "Values" option. This might help you. Thanks, Shail wrote: I have two workbooks and would like to copy a page from Workbook A into Workbook B. However when I do this the page I copy always references Workbook A in the formulas. Is there any way to copy a sheet without this happening? example: formulas look like =[WorkbookA.xls]Data!D11 - I don't want the [WorkbookA.xls] included after copying, it should just read Data!D11. There is already a sheet in the new workbook titled Data that I would like it to point to. Any help would be greatly appreciated! Matt |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Spreadsheets without referencing other workbook.
hi,
copy and after replace =[workbooka.xls] per = hth regards from Brazil Marcelo " escreveu: I have two workbooks and would like to copy a page from Workbook A into Workbook B. However when I do this the page I copy always references Workbook A in the formulas. Is there any way to copy a sheet without this happening? example: formulas look like =[WorkbookA.xls]Data!D11 - I don't want the [WorkbookA.xls] included after copying, it should just read Data!D11. There is already a sheet in the new workbook titled Data that I would like it to point to. Any help would be greatly appreciated! Matt |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Spreadsheets without referencing other workbook.
Hi,
Marcelo has good option for you. You can Replace (Ctrl+H) [WorkbookA.xls] with a null value for all the cells so you won't get WorkbookA.xls before any of you functions. Thanks Marcello to you too. Shail Marcelo wrote: hi, copy and after replace =[workbooka.xls] per = hth regards from Brazil Marcelo " escreveu: I have two workbooks and would like to copy a page from Workbook A into Workbook B. However when I do this the page I copy always references Workbook A in the formulas. Is there any way to copy a sheet without this happening? example: formulas look like =[WorkbookA.xls]Data!D11 - I don't want the [WorkbookA.xls] included after copying, it should just read Data!D11. There is already a sheet in the new workbook titled Data that I would like it to point to. Any help would be greatly appreciated! Matt |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Spreadsheets without referencing other workbook.
I'm sorry I may not have been clear. I'm trying to copy a sheet from
one workbook to another. But when I do so all my cell references point to the other workbook. I want to keep the references just eliminate the references to the other workbook. Thanks! shail wrote: Hi Matt, If what I exactly understood by your question. Do not copy from where the name of the worksheet appears. Select all (Crtl+A) the Worksheet A and Copy all the cells. Open Worksheet B. Right click your mouse button at A1 of the Worksheet B and click Paste Special and select "Values" option. This might help you. Thanks, Shail wrote: I have two workbooks and would like to copy a page from Workbook A into Workbook B. However when I do this the page I copy always references Workbook A in the formulas. Is there any way to copy a sheet without this happening? example: formulas look like =[WorkbookA.xls]Data!D11 - I don't want the [WorkbookA.xls] included after copying, it should just read Data!D11. There is already a sheet in the new workbook titled Data that I would like it to point to. Any help would be greatly appreciated! Matt |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Spreadsheets without referencing other workbook.
you are welcome thanks for the feedback
regards " escreveu: Thank you Shail and Marcelo, the find and replace worked. That was so simple I never even thought about it. Thank you once again. wrote: I'm sorry I may not have been clear. I'm trying to copy a sheet from one workbook to another. But when I do so all my cell references point to the other workbook. I want to keep the references just eliminate the references to the other workbook. Thanks! shail wrote: Hi Matt, If what I exactly understood by your question. Do not copy from where the name of the worksheet appears. Select all (Crtl+A) the Worksheet A and Copy all the cells. Open Worksheet B. Right click your mouse button at A1 of the Worksheet B and click Paste Special and select "Values" option. This might help you. Thanks, Shail wrote: I have two workbooks and would like to copy a page from Workbook A into Workbook B. However when I do this the page I copy always references Workbook A in the formulas. Is there any way to copy a sheet without this happening? example: formulas look like =[WorkbookA.xls]Data!D11 - I don't want the [WorkbookA.xls] included after copying, it should just read Data!D11. There is already a sheet in the new workbook titled Data that I would like it to point to. Any help would be greatly appreciated! Matt |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Spreadsheets without referencing other workbook.
thanks for the feedback Shail
regards from Brazil Marcelo "shail" escreveu: Hi, Marcelo has good option for you. You can Replace (Ctrl+H) [WorkbookA.xls] with a null value for all the cells so you won't get WorkbookA.xls before any of you functions. Thanks Marcello to you too. Shail Marcelo wrote: hi, copy and after replace =[workbooka.xls] per = hth regards from Brazil Marcelo " escreveu: I have two workbooks and would like to copy a page from Workbook A into Workbook B. However when I do this the page I copy always references Workbook A in the formulas. Is there any way to copy a sheet without this happening? example: formulas look like =[WorkbookA.xls]Data!D11 - I don't want the [WorkbookA.xls] included after copying, it should just read Data!D11. There is already a sheet in the new workbook titled Data that I would like it to point to. Any help would be greatly appreciated! Matt |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Spreadsheets without referencing other workbook.
Thanks Marcelo
Shail Marcelo wrote: thanks for the feedback Shail regards from Brazil Marcelo "shail" escreveu: Hi, Marcelo has good option for you. You can Replace (Ctrl+H) [WorkbookA.xls] with a null value for all the cells so you won't get WorkbookA.xls before any of you functions. Thanks Marcello to you too. Shail Marcelo wrote: hi, copy and after replace =[workbooka.xls] per = hth regards from Brazil Marcelo " escreveu: I have two workbooks and would like to copy a page from Workbook A into Workbook B. However when I do this the page I copy always references Workbook A in the formulas. Is there any way to copy a sheet without this happening? example: formulas look like =[WorkbookA.xls]Data!D11 - I don't want the [WorkbookA.xls] included after copying, it should just read Data!D11. There is already a sheet in the new workbook titled Data that I would like it to point to. Any help would be greatly appreciated! Matt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data referencing and auto fill across worksheets in one workbook.. | Excel Worksheet Functions | |||
| Copying worksheets into one workbook... based on content | Excel Discussion (Misc queries) | |||
| Copying charts from workbook to workbook | Charts and Charting in Excel | |||
| How do I save an Excel workbook so that cells referencing another. | Excel Discussion (Misc queries) | |||
| Copying From workbook to workbook | Excel Worksheet Functions | |||
Linear Mode
