Free Microsoft Excel 2013 Quick Reference

hOW DO i COPY FORMULAS FROM ONE SPREADSHEET TO ANOTHER IN EXCEL

I am working with two screens, I need to copy formulas from one spreedsheet
to another, but it doesnt work. (Both in excel). I use paste especial and
then appears the cell in the new spreedsheet with =EMBED ("Excel.sheet 8","").

Can you explain me in detail how do I have to do it??

Thanks a lot,

Isabel


Post your answer or comment

comments powered by Disqus
I am working with two screens, I need to copy formulas from one spreedsheet
to another, but it doesnt work. (Both in excel). I use paste especial and
then appears the cell in the new spreedsheet with =EMBED ("Excel.sheet 8","").

Can you explain me in detail how do I have to do it??

Thanks a lot,

Isabel

How do I copy a formula from one workbook to another so that the pasted
formula does NOT have a link back to the copied workbook...... WITHOUT
redirecting/editing the Link?

how do you copy hyperlinks from one worksheet to another and change the
hyperlink to reflect the sheet being copied to rather than the original sheet.

How do I reference data from one worksheet to another worksheet cell with a
combo box and then have the data relating to this appear in the nesxt cell in
a combo box.

ie.- Workssheet 2, cell D6 need to reference worksheet 1 cells C2 & C3
(Documents) then have cells A2 to A12 ( Document Issues) in worksheet 1
appear in cell E6 in Worksheet 2.
Also I will have multiple cell references from worksheet 1 to worksheet 2
following this simular format into cell D & E6. Then it needs to put this
information into individual rows on worksheet 2.
ie- choose data for D6 then E6 and goto the next row for adding additional

Thanks in advance for your help.

How do I reference data from one worksheet to another worksheet cell with a
combo box and then have the data relating to this appear in the nesxt cell in
a combo box.

ie.- Workssheet 2, cell D6 need to reference worksheet 1 cells C2 & C3
(Documents) then have cells A2 to A12 ( Document Issues) in worksheet 1
appear in cell E6 in Worksheet 2.
Also I will have multiple cell references from worksheet 1 to worksheet 2
following this simular format into cell D & E6. Then it needs to put this
information into individual rows on worksheet 2.
ie- choose data for D6 then E6 and goto the next row for adding additional

Thanks in advance for your help.

How can I copy data from one spreadsheet to another while keeping the
formats, column widths and row heights in tact? When I do a copy and paste,
the data doesn't look the same when it's pasted.

How can I copy data from one spreadsheet to another while keeping the
formats, column widths and row heights in tact? When I do a copy and paste,
the data doesn't look the same when it's pasted.

hi

i would like to copy some formulas from one spreadsheet to another similiar spreadsheet but when i merely copy and paste the formulas, excel remembers that the formula was linked to another sheet and caries this link.

Is there a way I can get excel to copy the formulas and paste them but without remembering the formulas are linked to another sheet in another workbook. The workbook I am pasting into has sheets with exactly the same names i.e.

Thanks for the help!

In copying formulas from one spreadsheet to another they maintain a absolute
reference to the original spreadsheet. How can I copy fromulas from one
spreadsheet to another with relative cell references without editing the
formula each time?

how do i take data from one spreadsheet to another? I'd like to link date form one cell to another on a new spreadsheet, i need to do this more then once, i'd like to have a main databass that is fed from all the other spreadsheets

anyhelp would be greatful

Dear Tomcat,
Easy way of doing it is, edit the formula in formula bar, then copy the
formula as as plain text and then paste it to the place you wish to paste.
Excel will simply understand it as currently typed formula.
Rgds,
PDS.

"tomcat" wrote:

> I want to copy a formula from one work sheet to another without the formula
> making a link in it...
> I am using the latest excel version. Is there any way to make it "NOT"
> insert the link to the copied spreadsheet?

at the moment I am keeping all my records and accounts on one worksheet but I
think it would be easier to keep separate worksheets, but this would require
being able to automatically copy from one worksheet to another. Can this be
easily done?

I haven't been able to find a solution to my problem while I am trying to
link text from one workbook to another. I am not to familiar with formulas
for text.

How do i copy data from one sheet to other :

This data is for two days :

Date Type U H M L
19-Oct-09 A 1 1 0 3
19-Oct-09 B 0 0 3 4
19-Oct-09 C 0 0 3 6
18-Oct-09 A 1 1 0 3
18-Oct-09 B 0 0 3 4
18-Oct-09 C 0 0 3 6

What I want is:

1. copy three lines of data ($C$2:$F$4) from this workbook (source.xls) above leaving first two columns and paste it in ($C$4:$E$6) on first sheet of second workbook (name might not be sheet1) in destination.xls

Likewise, copy next three lines from source.xls ($C5:$F$7) and paste it in second sheet of destination.xls at the location ($C7:$E$9)

likewise copy next three lines from source.xls ($C8:$F$10) and paste it in second sheet of destination.xls at the location ($C10:$E$12)
and so on

Is this possible?

In Office 2000.

I have a spreadsheet, and I open another instance of Excel. In the first
spreadsheet I select some rows and columns and copy them. I then paste them
in the second spreadsheet.

The values copy, but the format and formulas do not.

Paste -> Special gives me options to paste in the range of cells as an image.

So how do I copy the formulas from one spreadsheet to another?

In Office 2000.

I have a spreadsheet, and I open another instance of Excel. In the first
spreadsheet I select some rows and columns and copy them. I then paste them
in the second spreadsheet.

The values copy, but the format and formulas do not.

Paste -> Special gives me options to paste in the range of cells as an image.

So how do I copy the formulas from one spreadsheet to another?

I have written macros in excel for which I use regularly. I want to copy
them to a new PC however I am unable to do so. How do I get them from one pc
to another?

I am trying to copy formulas from one workbook into another. I highlited the
desired cells, selected ctrl c, opened the new workbook and selected ctrl v.
It copied the values in the first workbooks cells, but not the formulas. Any
idea what I am doing wrong?

Hi,

I have a question in regards to copying the formula from one cell to another cells in excel 03.

For example,

cell "C3" has a formula namely if(a2 = "OK", a2, "false")

I would like C4 all the way to C10 to have the same formula. Rather than putting in the formula into the cell by using (ActiveCell.FormulaR1C1), i was thinking if there is away of copying the formula as it goes. So i tried the code below and got error with message "autofilled failed"

        Set SourceRange =
Worksheets("Department").Range("K" & (myoldno - 1) & ":K" & myoldno)
        
        i = 0
        j = myoldno + 1
        myWantedrows = "A" & j
        While i < mynumber
            Worksheets("Department").Range(myWantedrows).EntireRow.Insert shift:=xlDown
            i = i + 1
            j = j + 1
            myWantedrows = "A" & j
        Wend
        
        Set fillRange = Worksheets("Department").Range("K" & (myoldno + 1) & ":K" &
j)
        SourceRange.AutoFill Destination:=fillRange
What i would like it to do is as it inserts new rows, it also copies the formula from the previous one and pastes to the cell of the new rows.

Thank you in advance

Hi,

I have a spreadsheet with thousands of rows of text that I need converted from one language to several other languages.

Is there a macro I can use that taps into some free service, running down my page and giving a foreign language conversion for each cell?

If not, is there some other way I can do this free?

I'd really appreciate any help anyone could offer.

Thanks so much in advance.

Ana
http://www.camp-hunt-shoot.com

I need to copy data from one sheet to another in the same workbook. The data is never the same and can change without notice. Here is what I need to do:

The trigger will be in column A with the cells content being 1 through 85 (never all 85 numbers though, mostly 1 to 10 sheets need to be created). As I said it is not consistent and sometimes new ones are added or some are deleted.

For instance, if you find a 1 in column A1 and there is not a sheet named "1" then create it and copy all of the rows that have a 1 in column A. When column A changes to another number say 5, create a new sheet and redo the above until all is copied into separate sheets. My problem is that I don't know how to create a new sheet when the number in column A changes.

I hope that this makes sense and someone can help me with the code. Thanks.

Hey guys.

I was wondering if someone could help me. I am writing a vba script that
takes in data, analyzes it, and then copies the results to a new file. I am
having a problem with two things.

1) I am using a template for the new file so there are a lot of formulas
(sums and std) already defined and ready to use. However, there are some
instances where there is a random amount of additional data I have to put in.
So, I have to apply the same formulas to this new data. How do I copy
formulas from one cell to another (allowing for a change in row) in vba?

Lets say cell(1,4) has the formula "=sum(A1:C1)
If I do: cells(4,4).formula = cells(1,4).formula
then cell(4,4) has the formula "=sum(A1:C1)"

How do I make it become "=sum(A4:C4)" using vba?

2) For these new cells, I also have to format some columns (currency, date,
etc) them and also put borders around them. How do I set these properties in
vba?

I greatly appreciate and assistance you could provide.

Thanks,

-Michael

In a workbook, with a master sheet copied many times, how do I copy formulas
from one sheet to another and have those formulas refer to the destination
sheet rather than refering back to the source sheet. I seem to remeber this
in the distant past but can't remeber how to make these formulas refer to the
destination sheet and not the source from whence they were copied.

Is there a macro I can create in order to copy or move data from one
spreadsheet to another?

We have data sheets showing our reps achievements. The data sheet has been
updated with new objectives and calculations. Some of the cells are locked
and protected. The locked cells are where they cannot be selected, so there
are blocks of cells only that require copying to the new data sheets.

Is there a way to automate this so we don't have to copy and paste the
information manually?

Any help will be greatly appreciated!

Thanks,
Cheri


No luck finding an answer? You could always try Google.