Hi
I am trying to create a master budget sheet which gets automatically updated when data is inputted into individual project worksheets. I have found this code which is apparently meant to do it but I can't seem to adapt it to my workbook. I tried changing the ranges but it came up as an error.
I have attached my workbook. any help would be much appreciated
Please Login or Register to view this content.
Last edited by welshgirl89; 10-07-2010 at 05:45 AM. Reason: add code tags for newbie pm warning
Why have several sheest. One sheet to contain all the data then ideally summarise using a PivotTable
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
It's just the way my boss wants it to be displayed as he hasn't much experience with excel. So i'd like it once information is inputted in project A for example it will automatically copy to the master sheet.
Thanks
Hi welshgirl89
the sheet name was incorrect
Please Login or Register to view this content.
Pike thanks thats great.... only one problem is that when new data is added it doesnt go to the next new line in the master sheet. the data groups together via the project group. How would i change that? Thank you so much for your help!
welshgirl89
you could try changingtoPlease Login or Register to view this content.the 2 adds another rowPlease Login or Register to view this content.
that just adds a new row inbetween the data of each project group. is there no way it can just add to the next free row in the master sheet?
also, is there a macro or a shortcut to run the code when just on the excel spreadsheet so once the new data can be added a button just needs to be pressed to automatically run it? tried creating a macro to do it but it didn't work.
thanks again!!
welshgirl
Not sure what this meansOriginally Posted by welshgirl89
Say for example I already have data in the master sheet from all worksheets. When i add new data to ProjectA worksheet and run the code, it copies it underneath the previous ProjectA data in the master. Same with project B, if new data is added in its worksheet, then it copies it directly underneath the last project B data in the master sheet. I just want any new data to go in the next available row. Hope this makes sense!!
hi welshgirl89,
I think it does that ?
unfortunately it doesn't, it just seems to group them by the project sheet in the master sheet. When i entered new data in project A it didn't go to the bottom in the next available row.
You don't need to activate the sheets. This code should copy all the data to the next empty row in the master sheet for each sheet.
Please Login or Register to view this content.
I've added error handling & turned off calculation to speed up
Please Login or Register to view this content.
its still not going to the next free row, its grouping them by their projects in the master sheet
Your sheets need to be identical, one had an extra row
it's still doing the same! i think i am just going to have to accept it won't work! thank you for all your help!!
welshgirl89
can you attach your workbook with the added row?
Because you want them group per worksheet?
here is my attached worksheet... you can clearly see they are grouped together via projects. I want them in order of when i added a new data. so for example 7/10/10 item was the last one to be added so i want it to be in the last filled row in the master sheet.thanks
Hi welshgirl89
two things
one get ride of sheet 5 which has no data and two change this line from
Please Login or Register to view this content.Please Login or Register to view this content.
that is still grouping via projects in the master sheet :s
Ok the code you first had updates the the master ingroups of the sheets
You want to place the last entry you have made to the master last row.
or be filtered in acending order by date?
I want it to go to the master last row please!
Hi welshgirl
luck it a wet long weekend
here is an idea i borrowed from Romperstomper
Place this code in the "Project A" sheet module
every time you leave the sheet it will update the "Master Budget" sheet if there have been new rows added
you can change and use it in sheets Project B and C ect....Please Login or Register to view this content.
Hi Pike
That doesn't really make any difference to my worksheet. It still groups them into projects. How would i got about the way of just ordering them via dates on the master sheet?
thanks
This works by date entered did you try it?
That works great thank you!! Just what i wanted!
Thank you for patience
woo hoo
okie dokie If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
One more question (sorry!)- i am adding more sheets and changed the names of the others (e.g project a, b c) and updated the code to go with it but its only projects a and b that seem to update now. is there anymore code i need to change other than the sheet names? thanks
ignore my last post, i had a play around and it works great! thank you again
I would like to continue the conversation -
I have 12 tabs and want to create 1 summary tab -
Anyone have any ideas? I would like to create a button on the first tab to auto populate new data to the summary tab as well.
All the tabs look alike too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks