If so please let me have the steps involved or where I get get a template to do this Thanks Howard. I am trying to prepare a simple Material Quantity List for some Steel materials. Hi all I've code some VBA code which produces an output file from a template. Newbie here and I don't know where to start I'm trying to set up a macro to when data is pasted to a TEMPLATE worksheet tab it will automatically copy and paste data to another sheet based on the month value.
Results 1 to 4 of 4. Thread Tools Show Printable Version. I need to set up an organogram of a company structure. If so please let me have the steps involved or where I get get a template to do this Thanks Howard. Hi Dave Thanks for the help. I managed to find a tool on Excel that has an organogram layout under smart art Regards Howard.
Ah, I was looking at that but I wasn't sure if you were using Excel or not, the organisation chart is available in previous versions of Excel. All times are GMT The time now is Resources saved on this page: Subscribe for Weekly Tutorials Helpful tutorials delivered to your email!
This is a really simple and e. This is a very. Okay, so I tried for hours to find a solution to this and have finally gotten frustrated to the point where i think asking here will be my best bet.
Basically I want to export data from excel worksheets to various places on a word document I had. I have created a word template as well as bookmarks for that template, as that seems to be the recommendation for performing such a task with excel. I basically have 1 constant worksheet that contains all my affiliates info Name, Address etc , which i'd like to use to populate some bookmarks in my word template, and then i have another worksheet for the previous month, indicating sales etc for that affiliate.
I intend on adding a new worksheet every month that i would use to create new invoices. Furthermore, i'd really like to be able to update a new file or perhaps a new page on the same file for each company with the use of a button, similar to the one's you'd see in an access form.
Let me know if you need me to clarify. Ask Your Own Question. Employee Shift Roster Template - Excel. Currently we use a totally manual spreadsheet which looks like a Rubik's Cube and does not offer any form of automation in order to speed up entry adn ensure no doubling-up or missing shifts.
A previous poster explained what I also need; there were no responses, so I thought I would try again. Free or low-cost, please. I will need to print out periodic reports. Here is the way the previous poster described it: I have a loan with a variable beginning balance and irregular payments with annual large payment.
And total interest paid, total pricipal paid If I change the starting principal, excel would recalculate all entries.
Newbie here and I don't know where to start I'm trying to set up a macro to when data is pasted to a TEMPLATE worksheet tab it will automatically copy and paste data to another sheet based on the month value. Can someone assist or can give some direction? I have a template that automatically populates the date field with the current date when opened, using today.
Users then Save As to have an archive copy of their spreadsheet. However, when they go back to access their saved sheet, the date changes from the created date to the current date. How do I stop this in Excel? Please help and thank you! Hi all I've code some VBA code which produces an output file from a template. Now, if I want to run the output more than once, I get an message asking if I want to overwrite the existing file which I always do.
I've tried turning off displayalerts but it's not working. Is there any way of turning this message off? They work on shifts and the operation is 24 hours. Each gets 30 minutes for breaks which is not paid. Pay is biweekly and overtime is anything over 40 hours. Currently, the template we are using looks like this sorry, I could not figure out how to paste it so you can see it in Excel layout: I am in desperate need for help.
The following can be used to simulate the same, and avoid having to achieve the same with VBA's IsDate function: Very new in this board. If I post this question in the wrong forum please bear with me. There is about 20 staffs in our department and I have made a spreadsheet with 12 tabs for each month of the year Jan-Dec.
If each staff have 15 days annual leave each year and how can I make a formular that can automatically calculate the balance of annual leave and entered in the tabs of the following months. For example if staff A used 5 days in Jan how can the balance of 10days be entered in the tabs from Feb-Dec. If he use another 5 days in July the remain balance of 5 days be automatically entered in the tab from Aug to Dec. Likewise if staff A took 2 days sick leave in Jan, and 2 days in Mar how can this sick days be automatically sum up in the months after.
I am doing this manually at the moment and it is very time consuming and also very easy to make mistake. Thanks and sorry for this long questions. Formula For Material Quantities - Excel. Hi Everybody, First post on the forum, have only recently joined and im hoping that someone can help me before my head explodes! I am trying to prepare a simple Material Quantity List for some Steel materials. The materials are all in specific sizes.
What i want to do is, as i input the length, width and height of the structure in the spreadsheet, the Material Quantity List will generate the quantity of each piece of material i will need. Does anybody know of a formula for this.
I have been trying to use the IF function and getting absolutely nowhere, all suggestions will be highly appreciated!! Hello, My Cell C3 is a numeric value I have set conditional formatting to make the text red and bold when the number is equal or less than 10, is there a way I can make cell E3 display a message when the C3 condition is true??
We have a workbook that does not allow us to use the Move or Copy command. When we right click on the worksheet and select Move or Copy, we are able to check the box to make a copy, but when we click OK nothing happens.
We have checked to make sure that the workbook and worksheet: Are not protected 2. That there are no hidden worksheets 3.