Hey guys!
I have this task which is driving me crazy!
Now my task looks like this: I have to compare two excel workbooks. One contains old data, and the other new data. Now I need to compare every worksheet from the file with new data. Sometimes there are lot of sheets & sometimes few sheets. If there is mismatch in data then code should bring that data into new workbook.
So far I have found below code. But it’s really not working Please advise.
Please Login or Register to view this content.
Hi Akulka,
What does your data look like and is it the same field by field and are there key fields? and,and ....
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Data differ each times. Sometimes I got A:F column data. Sometimes its hugh. Another thing I would like to tell you that both file have same filed & column. Volumes differs.
Can you post a couple of sample spreadsheets?
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
I have attached 3 workbooks where I explained my issue. The OUTPUT file gives you idea what I am trying to do. It is not mandatory that I need output what I mentioned over there. You can suggest me more good idea. At the end of the day I need to know where is data getting changed in both file so that I can pass in data quality.
Hi Akulka,
Must the routine search for these tables or are they always in the same place?
This works with your sample data:
Please Login or Register to view this content.
Last edited by xladept; 02-15-2014 at 05:51 PM.
This the main challenge because for each report table places are changed.
I am getting error on Set wt = Workbooks(T & ".xlsx")
Last edited by akulka58; 02-15-2014 at 06:51 PM.
Hi Akulka,
Do you need instructions on how to run it?
Plz help me.
Hi Akulka,
You need the set up that you sent me i.e.
Today's Book, Yesterday's Book and a Book named Output
Copy the code to the clipboard
In the Book named Output
Press ALT + F11 to open the Visual Basic Editor.
Select Module from the Insert menu
Type "Option Explicit" then paste the code into the white space on the right.
With the cursor between Sub and End Sub press F5 OR
Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macroname (Akulka)
Oh - I forgot to tell you to save the Workbook as Macro-Enabled - sorry
Th code is throwing same error. Another thing is can we use Application.GetOpenFilename command because I do have 60 different reports to compare & their worksheet names not always DATA1, DATA2, DATA3.
If it's a subscript error then you don't have a book named 2152014.xlsx??I am getting error on Set wt = Workbooks(T & ".xlsx")
I'll look into the GetOpenFilename option - but, it won't be today.
Maybe another forum contributor can help you?
And, thanks for the rep!
Last edited by xladept; 02-16-2014 at 01:39 PM.
Hi Akulka,
My plans fell through - try this and let me know of the next issue
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks