Search : in
By :

Copying rows into a different sheet.

Last answer on Nov 12, 2009 1:46:48 pm GMT kwik98, on Jun 7, 2009 10:12:21 pm BST 
 Report this message to moderators

Hello,
Heres what I am trying to do. I have a workbook with a "master" sheet that I enter all of the info on. I have other worksheets that have only certain parts of the Master sheet copied to each of them. As I enter information onto the Master sheet (by adding a new row) I want the new row and its info to appear in its correct place in the destination sheet. In other words, I add a new row and it's info into the Master sheet and I want it to be entered into the destination sheet the same way.
Not sure anyone can understand this but there it is. Any ideas?

Configuration: Windows Vista Internet Explorer 8.0

Best answers for « Copying rows into a different sheet. » in :
Copy rows based on a condition ShowCopy rows based on a condition Issue Solution Note Issue How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I've tried almost everything but...
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Download DVDFab Platinum ShowDVDFab Platinum allows you ot copy DVD. The program offers 8 different copy modes: Full disk, main movie, to split, to customize, Clone, to merge and to write data. It can: - copy onto a double layer DVD - copy onto 2 different disks - copy...

1

mubashir aziz, on Jun 8, 2009 4:58:53 am BST
  • +1

Actually it can be solved if only you explain that how you have data in other sheet ...... If you are inputting data from master to destination sheet then its not very hard else with some more trick it can be updated there especially when you are inserting new Row ........ don't you have some blank row and can just enter data over three and linked those rows in your destination sheet ......



Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

Reply to mubashir aziz

2

kwik98, on Jun 8, 2009 1:14:51 pm BST

Yes, I insert a new row into the Master sheet and enter info ont it. I want the exact same thing to happen onto the destination sheet. I want a new row added at the exact same place I added it to the Master sheet adn all of the info transposed there as well.

Reply to kwik98

3

mubashir aziz, on Jun 9, 2009 3:07:16 am BST

I'm doubtful about inserting a row in one sheet and auto updation in other sheet. I think it can be thru macro but i'm not master in macros ..... But if you info in same row and columns then you can just give linked of desired cells in other sheet and after inserting some new data in master just dragdown the formula in your destination sheet ....


Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

Reply to mubashir aziz

4

GK, on Jul 13, 2009 4:38:16 pm BST

Dear Friend,

I can understand ur requirement, i also faced the same problem.
It can be solved by creating macro.

To create Macro
-------------------

1.Click the record macro.
(U can set the Short cut key in the option displayed)
2.select the all rows u want to update in destination sheet .
3.Click CTRL+D
4.Stop the Macro

Now u can insert the new row in your master sheet,and go to destination sheet,
and run the macro by shortcut keys .Ur destination sheet will get updated with existing formulae.

Reply to GK

5

MisterPiz, on Nov 12, 2009 1:41:37 pm GMT

I am looking to change a macro that I have from a loop to find the last empty row, to inserting a row. My reference cell is C5, so the new row would be at C6. I would like to insert data (=model!S44:AZ44)

here is what I have....that I would like to change

' this macro copies the data by code and pastes it to the history data sheets
'
' 290

'This section captures the date and pastes it into the "history data" sheet.



Sheets("Data Input").Select
Range("AA1").Select
Application.CutCopyMode = False
Selection.Copy
Selection.Insert Shift:=xlDown
Range("D6").Select
Sheets("290").Select
Range("c5").Select



Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False

'this section copies the model data and goes to the appropriate sheet to paste

Sheets("model").Select
Range("S44:Az44").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("290").Select
Range("D5").Select

'this section finds the next open row and pastes the data

ActiveCell.Offset(1, 0).Select
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(1, 0).Select
Loop

Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False

Reply to MisterPiz

6

 MisterPiz, on Nov 12, 2009 1:46:48 pm GMT

I am looking to change a macro that I have from a loop to find the last empty row, to inserting a new at the top row. My reference cell is C5, so the new row would be at C6. I would like to insert data (=model!S44:AZ44)

here is what I have....that I would like to change

' this macro copies the data by code and pastes it to the history data sheets
'
' 290

'This section captures the date and pastes it into the "history data" sheet.



Sheets("Data Input").Select
Range("AA1").Select
Application.CutCopyMode = False
Selection.Copy
Selection.Insert Shift:=xlDown
Range("D6").Select
Sheets("290").Select
Range("c5").Select

ActiveCell.Offset(1, 0).Select
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(1, 0).Select
Loop

Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False

'this section copies the model data and goes to the appropriate sheet to paste

Sheets("model").Select
Range("S44:Az44").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("290").Select
Range("D5").Select

'this section finds the next open row and pastes the data

ActiveCell.Offset(1, 0).Select
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(1, 0).Select
Loop

Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False

Reply to MisterPiz