Re: Need some help - PLEASE

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I change my formulas to strings, copy|paste, then change my strings back to
formulas.

In the sending workbook/worksheet
select the range to copy
edit|Replace
what: =
with: $$$$$=
replace all

Copy and paste

Select the pasted range
edit|Replace
what: $$$$$=
with: =
replace all

(don't forget to fix the original sheet, too.)

Flipkid2 wrote:

Sorry that I only post when I need help, but I am desperate.

I am using a spreadsheet for work. It has 19 tabs on it.

The 18th tab takes numbers from many multiple cells from the first 17
tabs. Because the cells are not together, when I cut and pasted the
formulas, they were all out of whack and I had to correct a few hundred
cells one at a time. Also the first 17 tabs are tabs that are copied
from other sheets one at a time.

The 19th tab takes totals from the 18th tab

Anyway....I finally got the sheet the way I need it but here is my
problem. The last 2 tabs are tabs that I need to continually use. The
way I need to use it is to first compile the sheet with the first 17
tabs and then copy in the last 2 tabs. The problem is that every time
I paste in the last 2 tabs, it changes the formulas to include the file
name of the original sheet. I have tried a million different things and
can not figure it out.

Hopefully I have explained this clearly enough so that someone can help
me.

--
Flipkid2
------------------------------------------------------------------------
Flipkid2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17984
View this thread: http://www.excelforum.com/showthread.php?threadid=569455

--

Dave Peterson
.

Relevant Pages

  • Re: Could this be possible?
    ... between First/Last in a particular position on the summary sheet, ... The sheet name could be anything, but they should be between the tabs ... What i wanted to do is arrange the numbers in a single cell (might be ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Could this be possible?
    ... etc. but I want to read what is in "myList" from my summary sheet. ... The sheet name could be anything, but they should be between the tabs ... What i wanted to do is arrange the numbers in a single cell (might be ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Hiding Tabs
    ... So this will look at a range of cells and show the worksheets based on ... You could use a select case for each of the tabs desired. ... ) Is Nothing Then Exit Sub ... Right click sheet tab>view code>insert this. ...
    (microsoft.public.excel.programming)
  • Re: Excel sheet display
    ... maybe you just can't see the worksheet tabs. ... hit ctrl-r to see the project window. ... you'll see the sheet names ...
    (microsoft.public.excel)
  • Re: Vlookup
    ... "chefmike" wrote in message ... The first 4 tabs are the weeks of the month and the last is summary or the ... Lets say sheet 1 thru sheet 4 cells A1 will be ...
    (microsoft.public.excel.misc)