Email:      Pass:    Pass?
Advertisements


Free Excel Forum

Transfer Data Between Worksheets

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I have one worksheet that has all of my information, and I would like to set
it up that if a certain cell changes, that row gets moved to another sheet.
Is this poosible? If so how would I go about doing it?



Similar Excel Video Tutorials

Helpful Excel Macros

Delete Hidden Worksheets
- This macro will delete all hidden worksheets within a workbook. When you run this macro a warning window will pop up for
Combine Multiple Workbooks into One
- This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and workshe
Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means
Replace Formulas with Values (For The Entire Workbook)
- This macro will convert every formula in an entire workbook into its respective value. This is basically a quick way to
Vlookup Function That Searches The Entire Workbook - UDF
- This UDF is a Vlookup function that searches the entire workbook in Excel. The syntax and usage of the function is exac

Similar Topics







I am trying to create a workbook where the values on worksheets 2 upwards are summarised on the first sheet eg
value in sheet 2 cell $G$3 needs to be moved to Sheet 1 cell H 2
value in worksheet 3 cell$ G$3 to sheet 1 cell H 3
value in worksheet 4 cell$ G$3 to sheet 1 cell H 4
value in worksheet 5 cell$ G$3 to sheet 1 cell H 5
value in worksheet 6 cell$ G$3 to sheet 1 cell H 6
value in worksheet 7 cell$ G$3 to sheet 1 cell H 7

I need to find a simple formula for doing this without having to type in every formula separately.


I have spreadsheet with a shopping list. Once the quantity is updated, the
information is moved to another worksheet. I have several of these worksheets
for different departments. (For more detailed information search for 'Moving
information' in Excel worksheet functions, its the one with 8 posts)

The information is moved to the other sheet by the following formula (THANKS
TO MAX!):
=IF(ISERROR(SMALL($D:$D,ROW(A1))),"",INDEX(X!A:A,MATCH(SMALL($D:$D,ROW(A1)),$D:$D,0)))

=IF(X!B2>0,ROW(),"")

I need the information derived from the above formula for each of the
departments to all be on one worksheet. . I tI have tried copying and pasting
the formula from each worksheet but it does not workhink there is an issue
with the cell referencing. For example in cell A1 the information for Dept 1
would begin. In cell A80 information for Dept 2 would begin. I have tried
placing the above formula to in cell A80 and changing the Worksheet (Index)
to the other worksheet but it still does not work.

I would really appreciate any assistance!

Thanks once again!





Ok, let me see if I can explain this correctly......

I have a worksheet that has the report to combine certain information from the other worksheets ( there are no spaces between rows).

e.g. Worksheet 3 Has rows 9,13,15 selected ( column A shows 1 and cell D is the information that needs to transfer to the main report worksheet ( worksheet 1... Next time it could be 4,8,23,26,31 same goes for all the other sheets. now there could be 8 worksheets that need to transfer

Now the cells that need to transfer, has to go under certain rows depending on the heading.. which means, it has to go to sheet 1 insert rows then insert what was in cell d of that worksheet and enter it in cell B.


e.g. this is sheet 1 ( main report )
row 1 5128640000 NON-HCEL 10 STA 5000000000 5003
row 2 5128650000 NON-HCEL 12 STA 5000000000 5003
row 3 5128660000 NON-HCEL 14 STA 5000000000 5003
row 4 5128670000 NON-HCEL 16 STA 5000000000 5003
row 5 5128520000 HCEL 4 STA STD 5000000000 5003


Sheet 2 example

qty step description

row 9 6 BRIDGE - MDL, SPCR 5092570000


row12 1 7 KIT-OP CNTRL PANEL, SPCR ECO

row15 7 KIT-OP CNTRL PANEL, BRIDGE ECO

same example for remaining worksheets...different rows..




So my question is How can i produce a Command Button, so when i am done filling in the worksheets. that it will automatically update the main report on worksheet one. Am I asking to much from Excel?

Thanks for ideas you have to offer...

Bill


Hey All,

Since my first post was a huge success, i have returned to see if anyone can help with my current problem...

I have Workbook with numerous worksheets,on one particular worksheet i require a formula/macro code that will pick up (say) those cells highlighted in red and then transfer that data set and the other selected information on that row to a another worksheet within the workbook.

E.g
Sheet 1 contains columns A to J;
Sheet 2 is where i require the information which is highlighted in red to be uplifted and pasted too.

so if Cell B2 contains the highlighted cell how would i uplift and transfer this along with data in cell C2,H2,I2 and J2 automatically to sheet 2.

I hope the illustration helps, i have tried to simplify this, your knowledge and assistance is greatly appreciated.

Many Thanks in Anticipation


I have a file (working.xlsm) in which I need to move information from one place to another.

The data that needs to be moved can be found in Y2:AW1220

All data must stay in the row it originated in.

The numerical value preceding the string must be transfered to the column associated with the string. (ie. Y2 should be moved to V2)

I can manually go back and delete the originating information. So clean up is not an issue just the transfer of data.


Hi All:

I have 5 workbooks and some have info also in different worksheets and i have the infomation for all the branches ranked like 47 branches. Now i need all this information to transfer to different worksheets per branch so 47 worksheets. I have done one template and i did it for one branch and i put the infomation by copyng the information with formula...now i dont know if there is a way that i can be copied in the other worksheets for each branch.....

One way is that i copy the first worksheet with the formula and change the row and drag it but still it will need time.

I hope someone can give me an idea as i will have to work for more than 2 days with it.

thank you a lot


I want to transfer 5 cells of data to 3 worksheets, Justin gave me a VBA that fransfers data to 1 worksheet but I cant workout how to transfer to 3 worksheets, I have attached a sample that works in part.


If I am in the same file, however using separate worksheets, how do I transfer info from one cell to another? For example, I might have 3 in A1 on worksheet 1 and want to transfer the info to B14 on worksheet 2 automatically (not having to copy).


Hi,

I am trying to transfer information from one sheet to another sheet instead of copying and pasting manually.

For example, sheet 1 has information about an employee:

Name- Email -Address - Phone number

I am trying to make a new sheet with more in depth information:

Name-email-date started - Extenstion- address - phone numner

I want to transfer the data already existing in sheet 1 to the corresponding boxes in sheet 2 and then I will add the new information.

Help?


Hi All:

I have 5 workbooks and some have info also in different worksheets and i have the infomation for all the branches ranked like 47 branches. Now i need all this information to transfer to different worksheets per branch so 47 worksheets. I have done one template and i did it for one branch and i put the infomation by copyng the information with formula...now i dont know if there is a way that i can be copied in the other worksheets for each branch.....

One way is that i copy the first worksheet with the formula and change the row and drag it but still it will need time.

I hope someone can give me an idea as i will have to work for more than 2 days with it.

I hope i was clear..! sorry my first time in this forum!
thank you a lot

Hi,

I have a sheet which contains data that is manipulated each day. The data has a Moved Date, and when this has been completed, I want this row to move to Sheet 3 from Sheet 1.

Basically, when a certain cell has been filled in (or a command button pressed) I want the information that has the Date Moved cells filled in to be moved to Sheet 3 from Sheet 1.

I would also like the contents of the cells on sheet 1 to be deleted, apart from cells in the A and D column. It is also important that the information put onto sheet 3 is made into a list, as in no information should be over written by the imformation being placed into the sheet.

I really don't know which way to tackle this one. I know it would be easy to copy & paste myself, but the excell program is to be used by others less technically minded, and copy and pasting isn't the best option. There is also a lage amount of data to be maniupulated each day, so automation is the only way to go.

Does anyone have any suggestions on which VBA code we could use to move the information? Would we need Checkboxes, or can it be done automatically based on the cell being filled in?

Any help would be much appreciated.

TIA
Gareth


I currently have a workbook where I have one worksheet where I enter some records and the first 5 columns with info about the records are copied to 3 other worksheets. On the 3 other worksheets I have areas to add more information about the records and some of these values are returned to the main worksheet. The formulas for this work good until I have to sort the information on the main worksheet. When I do that, the information on the other pages does not sort and the information that was entered on the other worksheets is still in their original rows now corresponding to incorrect records.

I am wondering if there is a way to be able to sort information on multiple worksheets at exactly the same time as to prevent the information entered from getting moved to other records.


Sorry if this has already been posted, I did have a quick search, but couldn't find anything.

My problem is that I have a large spreadsheet where I have information that I transfer from my companies in-house computer system and have got lookup's and sum if's function's in place, but it has got too large for the Pivot Table to work.

What I would like to try and do is have one main worksheet where I transfer all the data like I do at present, but have new worksheets where it picks out the information for Jan, Feb, March etc from the main worksheet automatically and is includes all the information from the main worksheet and is displayed the same but just for the appropriate month. This way would enable the Pivot Table's to work, but I don't know if there is a facility to do this.


Hi - I'm new to this, so please be patient with me. I know enough about Excel to be dangerous. To my problem.

I have created a worksheet for our company's accounting department for them to show a cost to complete on our projects. The information varies from project to project, so I need to find a way to search through one worksheet with the right information and transfer the information to the other worksheet and if it is not there then delete the row. I have attached both copies of the worksheets for a better understanding of what is needed. I would appreciate any help.


Sorry if this has already been posted, I did have a quick search, but couldn't find anything.

My problem is that I have a large spreadsheet where I have information that I transfer from my companies in-house computer system and have got lookup's and sum if's function's in place, but it has got too large for the Pivot Table to work.

What I would like to try and do is have one main worksheet where I transfer all the data like I do at present, but have new worksheets where it picks out the information for Jan, Feb, March etc from the main worksheet automatically and it includes all the information from the main worksheet and is displayed the same but just for the appropriate month. This way would enable the Pivot Table's to work, but I don't know if there is a facility to do this.

Someone has suggested that I could extract the data using a vlookup function, but I don't know how to do this. Would this work? If so what formula would I need?

Many thanks.


Hi Folks,

I have been working on a sheet for monthly graphs. I have managed to create the code getting the spreadsheet to look how i require and get all the information onto it.

However I need some help creating a code to do the following which is extracting the information from one sheet and placing it in the right location onto a different sheet.

Here is the layout i have:
I have two worksheets "Monthly Report" and "Monthly Graphs".

In column "O3" of worksheet "Monthly Report" is the month i am working on (this month is placed there earlier on by code).

In column "P3" of worksheet "Monthly Report"is the figures for this month.

What i want to do is transfer those figures to another worksheet "Monthly Graphs". So i need a code to do the following:
If column "O3" of worksheet "Monthly Report" says September.
Then i want to go to row "B2" in worksheet "Monthly Graphs"and find/match the column which has September in it.
Once it has found that column i want to place the figures from column "P3" of worksheet "Monthly Report" into row 4 of the matched column in worksheet "Monthly Graphs". Therefore i have transferred septembers figures from worksheets "Monthly Report" to "Monthly Graphs".

I hope this makes sense but if anyone needs more information then let me know.

I would really appreciate some help to do this.

Thanks

Mike


I have two worksheets: "Active Employees" and "Inactive Employees"

In those worksheets, each row is an Employee's information with Column E being the Employee's ID number.

I want to use a macro that implements an Input Box to prompt the user to enter the Employee's ID number of the Employee that needs to be moved from "Active" to "Inactive".

The macro would need to shift the rows up on the "Active" sheet once the row is moved. For the "Inactive", the moved information would need to be inserted into the first blank row.

Any help would be greatly appreciated.


I have a master spreadsheet that lists a variety of alph and numeric information in different cells according to heading, (e.g. - client, address, phone #, part #, serial #, etc).

The master sheet has too much information and is too large to print for our field tech's, that only need some of the info on hard copy. I wanted to make a 'short' sheet, which would only be one page wide, offering partial information that we could print. At first I just copied the columns that were appropriate and made a second 'short' worksheet. Due to the fact that information changes on a regular basis, I found it bothersome to keep going to two worksheets and upgrading. I rebuilt the 'short' worksheet by referencing cells in the 'master' worksheet, which worked, however, now I find that if I add a row to the 'master', it doesn't reflect in the 'short'.

Formatting is as follows:

Cell A3 of the 'short' worksheet contains ='master'!A3
Cell B4 of the 'short' worksheet contains ='master'!B4

If I insert a new row into the 'master' sheet, between 3 and 4, nothing shows up on the 'short' sheet but cell information on the 'short' sheet moves up one row number. (Obviously because that info on the 'master' has also moved up one row, due to the inserted row).

So - how do I get the new, inserted row on the 'master. to show up on the 'short'?




I am trying to figure out how to write a macro to insert data from one worksheet into another, but to plug it into the last date of each day. As an EXAMPLE, worksheet three in column A has 10-feb-00 TEN times, then 11-feb-00 FIVE times, 12-feb-00 TWENTY times, worksheet four has 11-feb-00 TWO times, I want to transfer the information from worksheet four into worksheet three but plug it into the LAST DAY of 11-feb-00. I need to do this for all the dates, and I can't figure out the language.

Here is an example of what I am looking for:
http://wikisend.com/download/290610/Example%20.xlsx

The highlighted cells on sheet 4 are what I need moved to sheet 3. I highlighted the cells on both sheet so you can see where I need them and how I need them placed. Anyone wanna take a stab at this?


How do I transfer a row of cells, which includes a date, over to another page and have it drop into the right area by date? For example, if i have work data created in July but, completed in August, how do I get that information to transfer into the month of August. I already use rows with named ranges and they transfer fine into other worksheets in the proper order, but, I'm trying to get the info to transfer into another worksheet according to the month it was completed. Can you help??? There may be work as far back as 3-4 months that finally completes. When it does, I need to get that info transferred into the month it actually completes.


I am summarizing data from individual worksheets to a compilation sheet. The worksheet has headings that utilize the first three rows.
My data copies to the compilation sheet but starts on row 3 overriding the headings. The information is in the correct colums but overrides the headings and since the headings are in bold that information is also in bold. All the other sheets in the worksheets transfer sequentially down in the correct fashion and total correctly.

It is just that first sheet that is incorrect.

Any suggestions.

Thank you.


Need some assistance ... any help will be greatly appreciated

I have one form that is transferring data to two different sheets in Excel. The first transfer is working. Believe that I am close but the code currently is not working. This code is placed under the first transfer and the delete commands are after this. What am I missing? .... lol This transfer has to go to cell C,8 in the CurDB worksheet.


'copy the NEW DATA Yardage to Current View/Last Round database
Dim iRow As Long
Dim ws2 As Worksheet
Set ws2 = Worksheets("CurDB")
ws2.Cells(8, "C").Value = Me.Yd1.Value
Exit Sub
End If

Thanks again for the help

Bob


I have a workbook that I use to admit people into the building I work in. I am trying to come up with a formula that will, if there is information typed into cell d11, then transfer that info to the second worksheet and when the info in in the second worksheet; cell e11, then copy the information from cells a2, a4,a6, d2,d4 onto the cells b12, b14, b16, on the second worksheet. (of course if there is no information in cell d11 then nothing should happen)

I have tried to use the conditional formulas and haven't had much luck as I have only used them once and that was 3 years ago. I should also tell you that the information being shared between worksheets is not always numbers, most often it is a name, street address or birth date.

Thank you in advance for whatever you can do for me.


All my dear Friends :
Kindly help me out on the issue i am struggling for. How can I do the following ?


In a work book I have a work sheet (say Sheet4) which saves the data fed from a User form. The data is stored from 2nd row onwards i.e. from A2 to R67. I want to transfer some of the selected cell ranges of data to another worksheet (say Sheet10). The data transfer should be like this :

Sheet4 to Sheet 10

Cells A2 : F67 Cells A5:F70
Cells R2:R67 Cells G5:G70
Sheet7 to Sheet 10

Cells I2:M67 Cells H5:L70

Sheet8 to Sheet 10

Cells C2:C67 Cells M5:M70
Cells G2:G67 Cells N5:N70
Cells J2:C67 Cells P5:P70

I want to transfer these cells from the worksheets to Sheet 10. I donot want to make copy & link paste. Can any macro be written for this.

Request an early help please.

Thank you all.

nm766

I have a workbook called 'QSMA12_16'.

I have about 30 or so worksheets in this workbook (one for each student who does the subject ... plus a few other necessary sheets, like 'Synergetic Transfer').

In the worksheet called 'Synergetic Transfer' in cell range A4:A33 I have each of the students ID numbers. In cell range B4:B33 I have each of their names.

In cell range C4:C33 I'd like to have returned their particular result for an assessment item. Each student will have this particular result found in their particular worksheet in cells DK10 and DK11.

So I need a formula in 'Synergetic Transfer!C4' that will look at the student name in cell B4, then look for the worksheet with that same student name, and return the concatenation of cells DK10 and DK11 from that particular student's sheet.

I suspect it will need the function 'INDIRECT' but I don't know how to put it together.

Is it possible ?

Chris