One Click UPDATE using VBA or Excel Functions

P

Psionicrnd

New Member
Joined
Jan 3, 2014
Messages
9
Hello...

Is is possible to Update the master sheet with data from sub sheets in one click? Let us say we have one Master Sheet and Three sub sheets with name A, B, C. I would like to have excel function on Master sheet or Update button on Master sheet by which if i click on that it should copy all data except labels from A, B, C to Master sheets and also while copying one column should get auto filled based on from which sheet the data been copied. For example- If 10 data copied from A sheet on column X should show A, if data is copied from B, it should show as B...and so on..Hope its not much confusing. Sorry I am not an expert in such matters..ty
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
Marking it CLOSED as I posted the same question somewhere else. I cant delete this post as I dont find any suitable option to do so....Ty and I apologise
 
Upvote 0
You must log in or register to reply here.

Similar threads

Chris_010101
  • Solved
Simple VBA Code help
2
Replies
12
Views
543
Chris_010101
Chris_010101
A
  • Question
Worksheet from a template using a master list but protecting existing worksheets
Replies
0
Views
263
Alfalfa166
A
N
  • Solved
VBA to separate three tabs form master and paste existing data's in it as "values" (no link to master when separated)
2
Replies
14
Views
333
nscaria00
N
H
  • Solved
Consolidate data from selected sheets into master sheet & automatically update data.
Replies
8
Views
750
Joe4
Joe4
R
  • Question
Is there a way to open a file that Power Query has locked as Read-Only?
Replies
0
Views
144
rcrumbliss
R

Forum statistics

Threads
1,215,853
Messages
6,127,334
Members
449,376
Latest member
karenmccabe

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top