Free Microsoft Excel 2013 Quick Reference

can I automatically copy text from one cell to another in different worksheets

I have a SS at the moment, wher I have to Type in the clients name on 3 different sheets, is there a simple way I can have it populate the relevent cells on the other pages? They are not the same cell references.

I have managed to get it to work with figures using autosum, but when I try it with text, it just returns 0

BTW this is excel 2007
The Sheet I want to copy it from is called Quotation Information Cell B2 and the sheet I want it to go to is called Age in cell F1, I should be able to work the rest out from there

Thanks in advance

Post your answer or comment

comments powered by Disqus
One of my excel spreadsheets has started automatically copying data from one
cell to another (or rather ROWS of data) without displaying any formula or
explanation for the information. It seems to insert it about 10 - 20 rows
apart, just one cell, and slips it in before one can notice it happening...
Can anyone suggest anything?

I'm sorry if I'm just thick, but I can't find any function to automatically insert text from one cell into another. I don't want to do anything to the text, just automatically copy the text in one cell into another. This seems as if it would be so simple, but I can't work out how to do it. I have made sure that both cells - the target and the original are formatted as text, and I have looked through all the text related functions listed under "Insert > Function", but I haven't had any luck. I am using Excel 2003 & Windows XP Home SP2.


I'm trying to create a macro to copy text from one cell into another one. The only way I've found so far is with the simple formula ="cell of origin", but if I do this I'm then unable to modify the copied text in the receiving cell, if I try I lose the copied cell. Any idea?


I have a spread sheet, containing four columns. I want to extract some required text from one cell to another specified cell.

For example, I have two rows like 1. function and 2. modifier.

In Modifier the text is like "Function check of the engine".

So, I need the Function Check from the Modifier row and copy to the Function column.

So, in this same way, i have many other terms like, operating, process drain etc.. so, i need to extract the require text from the cell to another.

(please check the Attachment i Clearly mentioned in the Comments)

Is there any way to do this.

Hi everyone,

I'm going nuts trying to figure out how to autofill text from one cell
to another. For example, everytime I type text into cell A20, I want
the exact same thing to cell BL20. The same for B20, BL20, etc.

How do I go about that? I already know how to copy formulas from one
cell to another by dragging the skinny black line of the cell. I guess
I just need the formula for a simple IDENTICAL copying of text.

Thanks in advance,



I want to copy text from one sheet to another using a macro but I would like to copy the data and put it in a row below the last copied data. So I basically have a template which is always being updated but I would like to send the core details for each template to an overview sheet. Currently the core details just keep getting changed by the macro to the new template details. But I would like every template that is entered to be stored in a table on the overview page. Any help would be much appreciated.


Can anyone help me copy selected text from one cell to another? I have a long column with the text 'name : Joe Blogs' and need to delete the first part of the text 'name :' so I only have the text 'Joe Blogs' remaining in the cell. I have thousands of cells like this, and it will take me ages to delete each manually. Is it possible to do this with a function? please help asap!!

Hi Guys,

I am trying to copy text from one workbook to another with a formula, I have tried formatting the cells as text and general but no luck. I tried Concatenate and got the formula displayed but not the result.

Can anybody help



Is there a command that automatically sends data from one
cell to another cell once the first cell contains data. I
know that the usual way to do this is to use the copy
command: =Sheet1$X53 however this is 'pulling the data'
rather than having it be sent to another cell. However I
don't want to use this formula as I require that the
worksheet that the data is sent to has all unused cells
blank (as opposed to having unused cells containing the
copy command). The reason for this requirement is that the
worksheet needs to be imported into a system that rejects
blank cells with formula's in. (usually we have to delete
each unused cell).

I hope this makes senses - And I'd be extremly thankful
for any help!



I want to be able to automatically copy data from one sheet to another sheet
on the last day of the month (the sheets are in the same workbook) when the
user opens or saves it (either way would be fine)

On sheet 1 there is a running total say cell C3 and on sheet 2 the
destination cells Jan, Feb, March etc.

Is there a way to have my running total populate the correct months figures
while keeping the previous months total. Just now the user manually inputs
the figures but if I can automate this task it would save time for the user.

I hope that I have explained the problem clearly enough.....

Any help you can provide would be appreciated.


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,


Good Afternoon

I am attempting to copy Text from one cell and populate to another, e.g.

A1 = Excellent
A2 =
A3 = Good
A4 = Bad

If i type ='Sheet 1'!A1 in the cell on my second sheet it populates fine, however i need to be able to ignore blank cells as well

Any ideas, your help is most appreciated

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,


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.


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
        Set fillRange = Worksheets("Department").Range("K" & (myoldno + 1) & ":K" &
        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

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.

I want to jump from one cell position (on picture, marked with numbers from 1 - 6)
But i want to jump to them respectly(first to 2, then on 3....)
I have used these numbers just to describe space between cells(in rows and columns),
and actually those are blank cells!
Starting blank cell can be everywhere(e.g. A2), it doesnt matter, it is only important how to jump from one cell to another in mentioned manner!!!!!!!

Thanks in advance!!!!

I would like to transfer a number from one cell to another... problem is
that after I do calculations in one format, I need the number to perform
another calculation in another format... for example, I calculate time
to get my total time (in minutes), lets say the number is 231 minutes
in the [mm] format. I now need the 231 to be transfered to another
cell but I need it in a general number format. So how do I change the
format and keep the same number? Any suggestions or ideas?


I am tryiing to copy one cell to multiple worksheets without having to do
each one separately. Is there a way to do this?

I think this may be more of a spell check question than an Excel question but I need help with my Excel database so here goes:

How can I change recurring terms from one thing to another? i.e. I have the words "specialite domestique" in many cells but I want to change this term to its english equivalent so that my whole database is english only.

I would like to use a macro to transfer/copy data from one tab to another in the same file. Please see attached file and notice the "List" tab is what I have available and the "New" tab is what I'd like to transfer/copy the data to. I have tried using a formula; however, the file is too large to handle. I would like a macro if possible. I appreciate your time

Book 2.xls

What would be the function/formula to automatically move data from one sheet to another AS LONG AS certain criteria are met?

In my case:

IF in Sheet 1, cell B2 contains EITHER "FTIC" OR "TRANS" AND cell B4 contains "STU" then the text from D2 is copied into cell D2 in Sheet 2.

I hope this makes sense.

As always, thank you in advance for your help and assistance!

So, I got some code from the great people at this forum, and was wondering if it could be tweaked a bit.
The coded copies txt from one field to another, and puts itself at the top of the cell and removes the txt from the previous cell.
The problem is, if cells in the column are blank it has started to put a square symbol in, so when we autofilter it will show squares. I can work around it by filtering for the squares and deleting them manual which is still a time saver. The problem is if the squares get put in between other txt there's no way to delete them. I can live with it, but figured it would be worth asking, as it did not always do this.

Thanks in advance

Sub AJ2AI()
    Dim cell As Range
    Dim s As String
    Dim r As Range
    Dim sFrom As String
    Dim sTo As String
    Dim lFrom As Long
    Dim lOffset As Long
    Dim rRange As Range
    Dim rTop As Range
    Dim rBottom As Range
    Dim sh As Worksheet

    sFrom = "AJ"
    sTo = "AI"

    On Error GoTo EF
    Application.EnableEvents = False

    lFrom = Range(sFrom & 1).Column
    lOffset = Range(sTo & 1).Column - lFrom

    Set sh = ActiveSheet
    With sh
        Set rTop = .Cells(2, lFrom)
        Set rBottom = rTop.Offset(.UsedRange.Rows.Count - 1)
        Set rRange = Range(rTop, rBottom)
    End With

    For Each cell In rRange
        With cell
            Set r = .Offset(0, lOffset)
            s = r.Value
            If InStr(s, .Value) = 0 Then
                s = .Value & vbLf & s
                With r
                    .Value = s
                    .VerticalAlignment = xlTop
                End With
                .Value = ""        'remove this line if you want column(sFrom) to remain as is.
            End If
        End With
    Next cell

    Application.EnableEvents = True
End Sub

I'm looking for an excel macro that can copy rows from one sheet to another within excel based upon having a specific word in the cell. I have one sheet called master and sheet two called feedback. Here is an example of the data:

A B C D mary bob 56 reply soon sam john 26 keep in touch sylvia pan 15 response needed

I'd like to copy the rows sheet "master" to sheet "feedback" if the data in column D contains either the word reply or the word response somewhere within the paragraph. Additionally I would like to be able to fill in columns E and F in sheet "feedback" once the data has been copied.

Thank you in advance for your help!

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