VBA Copy from one File to Another

[freya306]

I have never used a VBA before but i want to copy some cells from one file to another.
I want to copy cells that will be on an order form to a sales sheet to collate all sales in one place so stock can be updated.
This means that the number of rows to copy each time will vary, the data I want to copy is formated into a table but i dont want to copy the headings row of the table.
In the sheet I want to copy the cells to it is a big table that each time i want to add to, not override and previous cells copied by the macro, Also in the original sheet once i have copied the cells to the secondary sheet can i overide the cells?
for this case I shall call the original file 'Original.xlsx' in location C:\Users\Me\
and the new file 'New.xlsx' in the same location C:\Users\Me\
[TABLE="width: 471"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Rijnsent]

Hi Freya,
what you describe is very well possible with VBA and not insanely complicated (although a notch above "macros, the first steps"). Could you post your files to showcase what you have and what you're trying to achieve? That is: a dropbox/google drive/etc. link, as I don't know which part of the sheet needs to be saved etc.
Thanks,
Koen