Excel 2007
I have two worksheets I would like to consolidate, I have watched a step by step video and gone step by step with it, I've even used Excel self help books with step by step visual instructions but I continue to get the message "No Data Consolidated" what is going wrong with this "No Data Consolidated" .....I have made sure my data was set up in the same exact order in both sheets so what is going wrong.
It would be good if you attach both sample files with dummy data. Should the entire data in worksheet2 be consolidated with the data in sheet1?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Since this forum is new to me, I don't see an option for adding attachments.
Last edited by Veron; 01-17-2012 at 08:03 PM.
To Attach a File:
1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks