|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 13th 12, 11:04 AM
posted to microsoft.public.excel.programming
|
|||
|
|||
Save record Into master sheet!
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). 
|
| Ads |
|
#2
July 14th 12, 04:06 AM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save record Into master sheet!
"mehtasanto" wrote:
> 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). Show what your data looks like right now. -- Promise me we'll only be as reckless as necessary.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Inserting a record into multiple tables based on the Master Table. | fbagirov | Excel Programming | 1 | October 15th 07 09:59 PM |
| Master sheet to split sheets back to another master sheet | FurRelKT | Excel Programming | 0 | May 11th 06 09:28 PM |
| Getting data from a closed workbook to a master record | Garcia[_2_] | Excel Programming | 0 | March 27th 06 02:16 AM |
| Master List Losing Record Due to Update from Links | Kenneth CN | New Users to Excel | 2 | December 7th 04 04:11 PM |
| Message Box if Attempting to Save over Master | sowetoddid[_26_] | Excel Programming | 2 | June 9th 04 03:25 PM |
Linear Mode
