TPortsmouth
New Member
- Joined
- Apr 6, 2017
- Messages
- 41
Hi mates,
I would like to seek help on building some Macro.
I have a table for end user data input, let's say monthly record of sales figure.
For example, row 2 is the first record, while B2, C2 & D2 are for end user's data input, and E2 is a formula.
I would like to create a Macro fro below purpose:
If I need to build such Macro, what should be the data source for copy? As I need a blank result data (where A5:D5 should contain null value, only the column E5 with formula should be copy). Do I need to create a blank dummy record for copy purpose?
Any idea? Your help is highly appreciated, thank you.
I would like to seek help on building some Macro.
I have a table for end user data input, let's say monthly record of sales figure.
For example, row 2 is the first record, while B2, C2 & D2 are for end user's data input, and E2 is a formula.
![doroyb.jpg](/board/proxy.php?image=http%3A%2F%2Foi66.tinypic.com%2Fdoroyb.jpg&hash=f0393be2aac93ee919e4ce2bb8af87c4)
I would like to create a Macro fro below purpose:
- Copy area A2:E2.
- Go to the last row of the existing data set (for this case is A5).
- Paste A2:E2 into A5:E5.
If I need to build such Macro, what should be the data source for copy? As I need a blank result data (where A5:D5 should contain null value, only the column E5 with formula should be copy). Do I need to create a blank dummy record for copy purpose?
![3460uux.jpg](/board/proxy.php?image=http%3A%2F%2Foi67.tinypic.com%2F3460uux.jpg&hash=a62d62c025fe47fa8b5f53d66bf09ddc)
Any idea? Your help is highly appreciated, thank you.