I have 2 sheet named "delivered", "Pending" & "all", In 1st two sheets I put data everyday to update. In "delivered" sheet my data ranges increase everyday but in "pending" sheet data range increase or decrease. Everyday I copy data from both sheet and paste in "all" sheet. I want "all" sheet to be updated automatically, is this possible please? Column header and column order are same in both sheet. From "pending" sheet I copy data without the column header.
Can you post your workbook with sensitive data replaced with something else so that we can get a good idea of what you are trying to do?
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank for your reply. Sorry for replying delay. here is my file.
After examining your 3 sheets, I wouldn't bother having the Delivered and Pending worksheets at all. They are just added work that can more easily be done on the All worksheet eliminating the copy and paste operations that you are now doing. By using the Filters at the top of the columns, you can work on the data that was in the two other worksheets that I have deleted from this workbook.
This makes the workbook smaller because of the lack of redundant data but the functionality is still there.
Last edited by newdoverman; 01-31-2014 at 10:28 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks