I am try to update our inventory workbook to make it more user friendly. I am having a problem with my master list. I would like it to update it's information off of the individual worksheets. I can not figure out how to do that except to do a cell reference and that does not always work. I am attaching a smaller version of what I am working on.
Abbyordertest.xlsx
Update what information?
Do you want it to have a copy of every line item from all the other order tabs?
How do you want the future state to behave and look? How is that different than the current state?
If I change information in one of the other sheets such as a part number or quantity I need to order I would like it to update the change in the master list. I need everything that is in each row on the different worksheets to be on the master list. I will need to eventually sort the items by supplier to make it easier to place the orders. The format should stay as is I just need to transfer information.
bump I need help please
So data from all the other tabs should go into the Master Order List? Even items from the Wesco Order List?
To ensure that the report creation and updation does not get messy, i can provide you a macro that clears the contents of the master tab and populates with fresh data. If you click the button again, it will clear contents and populate again.
If I have 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]
I would need the data from the sheets before the master sheet (Ballast, Boxes, Breakers). There are more sheets than what I put on this one. Then from the master list they would be sorted to the supplier sheets from the supplier sheets the will get copied to the order sheet to be ordered.
I hope this helps some.
Abby
Is this possible to do?
Try this codeCopy the Excel VBA code
Please Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks