Save record Into master sheet!

M

mehtasanto

Hi, I want to consolidate data from 10 different sheets into one sheet. Oneoption i have done is i have merged all the data from 10 sheets into master sheet. but there is one problem in this, if i need data on daily basis then i have to merge data from the first record. this consumes very much timeand system speed.

Now, what I want - I want to record data from each individual sheet to master sheet. As soon as I click on button, data will be transferred to master sheet from individual sheet( I tried using Vlookup & DGET function, but want to do using MACRO).
 
A

Auric__

mehtasanto said:
Hi, I want to consolidate data from 10 different sheets into one sheet.
One option i have done is i have merged all the data from 10 sheets into
master sheet. but there is one problem in this, if i need data on daily
basis then i have to merge data from the first record. this consumes
very much time and system speed.

Now, what I want - I want to record data from each individual sheet to
master sheet. As soon as I click on button, data will be transferred to
master sheet from individual sheet( I tried using Vlookup & DGET
function, but want to do using MACRO).
Click to expand...

Show what your data looks like right now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data consolidation 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Macro to Compile Data from Different Sheets 2
Macro to Format Multiple Sheets based on "Master" Format 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Copy range from multiple files in multiple folders to single sheet in master WB 10
Mail Merge Help 1
Create a dynamic master file 1

Top