Adding same data to multiple sheet

[Johnnyb827]

Hi all, I'm new here and would like to request some help if possible.
I have one sheet in Excel that contains User, Location and Quantity. I already have macros that adds the information into Sheet1. I would like to copy the contents of the User and Quantity automatically when my code is running. I tried over and over with other methods and have failed miserably. Thank in advance

Please Login or Register  to view this content.

[jaslake]

Hi Johnnyb827

From your description, I'm unable to visualize what you have or what you'd like it to be. You'll be best served to post what you have (including code) with an example of what you wish it to be.

John

[Johnnyb827]

I've attached the Excel file that I've been using so far. Basically when the macro runs, the Type, Location and Quantity should be added in Sheet1 and Sheet2. I just can't get it to write to Sheet2 simultaneously. Thanks in advance

[jaslake]

Hi Johnnyb827

Type, Location and Quantity should be added in Sheet1 and Sheet2

Your Sheet2 doesn't have a Quantity field. Getting Type and Location to Sheet2 shouldn't be a problem.

I'll work on this...but where in Sheet2 should Quantity go?

John

[Johnnyb827]

Thanks for the reply. Quantity should go between Location and Date Borrowed.

[jaslake]

Hi Johnnyb827

I've tested this on your sample file but, due to the late hour, not extensively. It worked on several iterations.

Please Login or Register  to view this content.

Let me know of issues.

John

PS: Be sure to add the Quantity field in Sheet2

[Johnnyb827]

Thanks! That worked like a charm. Thanks again for your help :D

[jaslake]

Hi D

Glad it works for you. If your issue is solved, please mark it as such. A tip of the scales is always appreciated.

John

[jaslake]

Hi D

Please change these lines of code from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

It probably will not make a difference unless things get "Out of Sync"

John