ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   macro - copy/add to another sheet (https://www.excelbanter.com/excel-discussion-misc-queries/258424-macro-copy-add-another-sheet.html)

puiuluipui

macro - copy/add to another sheet
 
Hi, i need a macro that will copy datas from sheet1 : J5 ;D13 ;D14 ;D15 ;F15
;E19 ;E20 to Sheet 2 to range A:G.
But i need the macro to paste to first empty row that it finds.
Every time i run macro, to add the informations to the next empty row.
The ideea is to add informations so i can create a small database.
Can this be done?
Thanks!

Dave Peterson

macro - copy/add to another sheet
 
Maybe this stuff from Debra Dalgleish's site:
http://contextures.com/xlForm03.html
and maybe...
http://contextures.com/xlForm02.html

puiuluipui wrote:

Hi, i need a macro that will copy datas from sheet1 : J5 ;D13 ;D14 ;D15 ;F15
;E19 ;E20 to Sheet 2 to range A:G.
But i need the macro to paste to first empty row that it finds.
Every time i run macro, to add the informations to the next empty row.
The ideea is to add informations so i can create a small database.
Can this be done?
Thanks!


--

Dave Peterson


All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com