EXCEL copy formulas 2

[jimstructures]

What did EXCEL do to copying formulas from one spreadsheet to another???

How does one get around this change?

Am I missing something very obvious?

Jim

 

[zelgar]

Try going to the cell, highlight the formula, copy & then paste to the other spreadsheet.

 

[JoelTXCive]

Highlight and copy the formula in spreadsheet #1. Then in spreadsheet #2 RIGHT CLICK where you want to past.

There are a range of Paste options available. You have to hover over the icons to see what they do, but you can paste the values only, formulas only, links only, paste with formatting included or not included. If you hit the "Paste Special" button, then I think you paste combinations of the just mentioned options.

 

[SkipVought]

...and keep in mind that the row or column of the cell that you paste the formula text into may very well need to be the SAME ROW & COLUMN as the cell that you copied the formula from.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[jimstructures]

I'm sorry I wasn't more clear. I'm trying to copy an entire worksheet or part thereof and paste it into a 2nd workbook as a new work sheet. I have done it in the past. But EXCEL was NOT being cooperative. I ended up asking the secretary to do it and she got it to work on the first try. I wasn't watching her so I don't know what swear words she used to make the computer cooperate.

Thanks for the assistance.

Jim

 

[IDS]

Jim - I'm still not clear what your problem was. If you tell us in what way Excel was not cooperative, we might be able to come up with a solution that doesn't involve bothering your secretary.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[IRstuff]

You right-click the tab of the sheet and select "Move or Copy...," which allows you to move or copy the entire sheet to the same workbook or any other open workbook. It's been like that for at least decade.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert!

https://www.youtube.com/watch?v=BKorP55Aqvg

faq731-376 forum1529 Entire Forum list

http://www.eng-tips.com/forumlist.cfm

 

[jimstructures]

I have developed a spreadsheet/workbook )i.e. multiple tabs) that has many of my spreadsheets in separate tabs/pages/sheets. I wanted to copy one of the sheets or some part of it to another workbook with some different sheets/tabs/pages. I was not careful in how I started the second workbook and I assume I had a separate instance of EXCEL. When I copied the part of the sheet I wanted EXCEL wouldn't let me paste it in the second workbook. I do this all the time in Lotus but EXCEL was being cranky. I know, I know they won't work exactly alike. I didn't know the right click on the tab (Thank you IRstuff) to copy the worksheet. I couldn't find the move command at all, except in the help file which seemed to assume it was readily available. It was one of these frustrating moments when you think you something should work but it won't. Before I started smashing the mouse I talked the secretary into trying to do it. She got it to work on her first try or so she claims. Anyway I have a lot of new thinks to try and see if they work now.

Thanks to all who made suggestions.

Jim

 

[davidbeach]

She probably had both open in the same instance of excel. Copy within an instance works very differently than copy between instances.

 

[JG2828]

Yes, I think davidbeach is right. I had many problems with copying data between excel 2010 windows when spreadsheets were opened in separate instances. I always opened the files in separate instances so I could have one workbook open on each of my monitors. However when attempting to copy between the instances, the formulas wouldn't copy over. Things seem to be working much better after switching to Excel 2013 and now 2016.

Read over the following two links. They should help clear things up.

https://support.microsoft.com/en-us...ibutes-into-a-workbook-in-another-instance-of

https://excel.tips.net/T003404_Copying_Between_Instances_of_Excel.html

 

[lilliput1]

One way would be to save as the master spreadsheet with another name then revise the input data. If the input is on a separate tab then copying & pasting of the entire tab is as follows: Click on the top left of the spreadsheet tab to highlight the entire page. Select copy and paste on the top left corner of the page to be revised. Note cell locations of formula or data on both should exactly be the same.

 

[lilliput1]

Note the top left corner cell is at the left of the column letter row and above the row number column.