VBA Code for auto updating information on a sheet with information from another sheet

**Nitro2481** · 12-28-2015, 08:42 AM

Hi Guys,

Not sure if this is possible but in my attached sheet I have 1 sheet (sheet 1 "fruit") of customers buying fruit, 1 sheet (Sheet 2 "Veg") of customers buying veg, and a summary sheet of them both (Sheet 3) In an attempt to save time & prevent double inputting I was looking for some code that would allow me update the third sheet automatically when first or second sheet is up dated. So basically the code I need in English is

Please Login or Register  to view this content.

Hope you can make sense of it.
Thanks in advance
Book1.xls

**zbor** · 12-28-2015, 08:46 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

VBA Code for auto updating information on a sheet with information from another sheet

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code for auto updating information on a sheet with information from another sheet

Re: VBA Code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need help with VBA code. Tons of code seperated in two, second part of code doesn't work.

[SOLVED] Pattern Building VBA Code - Working code, would like to use cleaner code

[SOLVED] Excel VB code. Message pops up while code running asking question. Code must not wait.

[SOLVED] VBA code for assigning a numeric code to text; then numeric code populates table

sir how to vlookup formula two line break in excel. sir my code is, this code is working a

[SOLVED] Pick up the Vendor code of a part code from looking the highest Qty of a part code

Bookmarks

Bookmarks

Posting Permissions