Excel 2007 : Macro help - copy from one sheet to another

**sludeking** · 03-09-2010, 09:06 AM

Hey,

I'm trying to help my dad in law with an excel file he will need for work.

I'm sure it's probably quite easy, but as I'm completely new to this more advanced excel it's not so easy for me. Anyway here is my problem.

I have 4 sheets. We only need to look at the two: "Jan. FP Income" and "Jan. Income".

On the sheet "Jan. Income"

Row 3 is filled out with the correct information.

Now what I would like help with is - The information in row 3, needs to be copied to the first available row in the sheet "Jan. FP Income" i.e. row 2 (the first available).

Then as one continues to fill in the various rows in "Jan. Income" those rows are automatically copied over to the next available row in "Jan. FP Income"

I hope you can help.
Sludeking

**JeanRage** · 03-09-2010, 09:28 AM

Hi,

As a first step, you have to make sure both sheets have the same structure for the copy macro to work properly ...
You can adjust this macro to your specific needs ...

Sub CopyMacro()
Dim i As Long
i = Sheet3.Cells(Cells.Rows.Count, "A").End(xlUp).Row + 1
ActiveCell.EntireRow.Copy Destination:=Sheet3.Range("a" & i)
End Sub

HTH

**sludeking** · 03-09-2010, 10:05 AM

Hey JeanRage,

I appreciate the macro and help, but as I'm quite new to this you wouldn't happen to have a tutorial on it somewhere?

**JeanRage** · 03-09-2010, 10:17 AM

Originally Posted by sludeking

Hey JeanRage,
I appreciate the macro and help, but as I'm quite new to this you wouldn't happen to have a tutorial on it somewhere?

This macro has only two instructions ...
the variable i finds out the last row used + 1 to reach the first available row,
the instruction to copy to destination is explained in Help ( F1 key )...

HTH

**darkyam** · 03-09-2010, 11:26 AM

Sludeking, please take a moment to read the rules and then update your title in accordance with rule #1. Thanks.

**sludeking** · 03-12-2010, 04:03 AM

Originally Posted by JeanRage

Hi,

As a first step, you have to make sure both sheets have the same structure for the copy macro to work properly ...
You can adjust this macro to your specific needs ...

HTH

Hey,

Where do I post this macro? In the formula bar? As I posted earlier, I'm not familiar with any of this, so as many details as possible would be great.

**sludeking** · 03-12-2010, 04:39 AM

Update. I tried something else, just for fun and this seems to do what I need on a very basic level which is fine.

The only problem is, sheet 'Jan Income' rows 5-10 doesn't have any values entered, but rows 5-10 on sheet 'Jan FP Income' show a bunch of 0's as the values.

Is it possible to hide these values or choose not to display anything in the cells, until a value is entered in sheet 'Jan Income' and then automatically placed in 'Jan FP Income'?