Updating Customer Workbook from Master Workbook

[ameenuksg]

Hi All

I have 2 excel workbooks with identical data with many columns and rows.

The difference between Master sheet and the Customer sheet is that Master sheet has formulas and Customer sheet has just values only.

On a weekly basis, I enter data for about 150 rows to the master sheet and then update the customer sheet with the same data.

I see it as a repetitive weekly task from which I could save a lot of time by using VBA I guess. If not I usually copy paste the updated data from master sheet to the customer sheet.

If a good soul could help me here with VBA to copy selected columns and rows of new data from the master sheet to the customer sheet, I would gladly appreciate it.

So here is what I would want the VBA to do:

1. Open the customer sheet with the 'blah blah' filename in a different folder
2. Copy the filtered rows of updated data from Master sheet from columns A to U
3. Paste the copied columns of new data onto the customer sheet after the last row of data
4. Repeat above steps 2 and 3 with other columns X to AD, then AH to AL and then finally AO to AQ
5. Data pasted onto the customer sheet should only contain values and format of destination's sheet's format only


Thank you in advance

Here I have mentioned the address of the site where I have posted the same question on another forum:

mrexcel.com/forum/excel-questions/1059663-updating-customer-workbook-master-workbook.html

[AliGW]

Rule 08: Cross-posting Without Telling Us

Welcome to the forum! Unfortunately, your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

No further help to be offered, please, until the OP has complied with this request.

[ameenuksg]

My sincere apologies to the forum, I wasn't aware of the rules, my mistake. Will not repeat the same in future.

[AliGW]

Thank you for adding the information requested.