How to create a simple formula for a data dump

**blue_izce8** · 05-07-2013, 07:23 AM

Hi all - Please help me create a very basic formula on how i could create a single data dump file. I'm fairly new in excel and still learning things. Here's what I would need to do.automatically transfer the data saved in the Raw Data sheet of all 13 employees.

Each employee has their own tracker that they update daily. They use Sheet1 to encode the data, there is a save button that they will have to click in order to transfer it to the Raw Data Sheet. I would like to know what formula i can use to transfer all the information from the individual Raw Data Sheet to a Dump File real time.

Thank you in advance.

**arlu1201** · 05-07-2013, 09:08 AM

Your employees will update the data in the same workbook or individual workbooks?

**blue_izce8** · 05-07-2013, 09:14 AM

hi arlu1201, thanks for checking my case. they have individual workbooks.

**arlu1201** · 05-07-2013, 09:22 AM

Are these files stored in one particular folder?

Also, do you want the data to be consolidated into one new file each time the macro is run or into an existing summary file?

**blue_izce8** · 05-07-2013, 09:27 AM

Yes. They save it in one folder.

I would like to have just one dump file which will be updated realtime, everytime anyone of them saves something in their individual files. Is this possible? Do you have a better suggestion?

**arlu1201** · 05-07-2013, 02:35 PM

Would the users using the files be making changes to the already existing rows?

Or maybe we could put in a code that states that as soon as a particular column is updated in the sheet, that entire row should be copied to the master file. But this code would need to be copied to each user's sheet.

Another alternative is to clear out the master file each time you run the macro and start loading it with data from the topmost row of each file. This way, there wont be duplicates incase the users happen to update any old data.

**blue_izce8** · 05-07-2013, 02:41 PM

hmm, i'm sorry but i'm not sure if i understood your question.

They will be using their individual files to encode the transactions they've worked on and has a standard format on how every information must be encoded.

**arlu1201** · 05-07-2013, 02:52 PM

Ok let me explain.

For e.g. user A has updated rows 2 to 20 on his file in week 1 and this has been added to the master file. Now, in week 2, he realises that he made a mistake so corrects week 1 data. In this case, if the macro is setup to only copy new rows that get entered, the error will not be corrected in the data.

However, if we copy the data from row 2 onwards directly into the master file, it will create duplicate records since there was already data for wk 1 there. So if we clear the data and then update, no duplicates will occur and also the errors will be corrected.

**blue_izce8** · 05-07-2013, 02:58 PM

thank you for elaborating.

No. Once encoded, they don't touch the transaction again. which means no duplicate will be created.

**arlu1201** · 05-07-2013, 03:01 PM

But how would we identify which rows are copied today compared to the old data?

**blue_izce8** · 05-07-2013, 03:04 PM

there is a macro created in sheet1 that allows them to save the information entered to "raw data" sheet. so the data that will be transferred to the dump will be from the "raw data" sheet of every employee.

there is also a date per transaction. can i send you a copy via email?

**blue_izce8** · 05-07-2013, 03:42 PM

just to add. there are specific columns in the Raw Data sheet that i need, which is A:L. Basically, i just need something that will collate the information in every Raw Data sheet of employee in 1 file (dump file)

**blue_izce8** · 05-07-2013, 06:32 PM

Please help me find a resolution and be more efficient..thanks

How to create a simple formula for a data dump

LinkBack

Thread Tools

Rate This Thread

Display

How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Re: How to create a simple formula for a data dump

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions