Hi,
I have two sheets that I am trying to copy the information into a MASTER BLOCK sheet without overwriting the previously transmitted information from another sheet. I have created a Button on each titled "Transmit" that the employee can click once they are done entering information into their worksheet (they add information to their own sheet throughout the entire day, so I figured it would be easiest for them to just Transmit the information onto the MASTER BLOCK sheet once all their information is input). I don't necessarily want to specify the range on the Master sheet in which the information will be dumped, as sometimes the BM sheet has no information, so there's nothing to transmit to the Master sheet.
The script I have attached to the Transmit Button on 'BM' sheet is (I recorded this macro but need to figure out how to modify to make it compatible with the other):
Sub BM()
'
' BM Macro
' transmits block entries from BM's sheet to Master sheet
'
'
Range("A7:L51").Select
Selection.Copy
Sheets("MASTER BLOCK").Select
Range("A7:L51").Select
ActiveSheet.Paste
End Sub
I have the same script for 'CD' sheet--even though I am wanting these to go to the next available row so that they don't overwrite each other...that's where my hang up is, I'm not sure what to replace my ranges with, I suppose; or how to say "next available row"
Is there also a way to track which sheet the information came from? I have a column titled "Added By" (column L) that it would be nice to have listed which sheet the information came from.
Thanks for any help you can offer!
I have two sheets that I am trying to copy the information into a MASTER BLOCK sheet without overwriting the previously transmitted information from another sheet. I have created a Button on each titled "Transmit" that the employee can click once they are done entering information into their worksheet (they add information to their own sheet throughout the entire day, so I figured it would be easiest for them to just Transmit the information onto the MASTER BLOCK sheet once all their information is input). I don't necessarily want to specify the range on the Master sheet in which the information will be dumped, as sometimes the BM sheet has no information, so there's nothing to transmit to the Master sheet.
The script I have attached to the Transmit Button on 'BM' sheet is (I recorded this macro but need to figure out how to modify to make it compatible with the other):
Sub BM()
'
' BM Macro
' transmits block entries from BM's sheet to Master sheet
'
'
Range("A7:L51").Select
Selection.Copy
Sheets("MASTER BLOCK").Select
Range("A7:L51").Select
ActiveSheet.Paste
End Sub
I have the same script for 'CD' sheet--even though I am wanting these to go to the next available row so that they don't overwrite each other...that's where my hang up is, I'm not sure what to replace my ranges with, I suppose; or how to say "next available row"
Is there also a way to track which sheet the information came from? I have a column titled "Added By" (column L) that it would be nice to have listed which sheet the information came from.
Thanks for any help you can offer!