Document Description OBJECT: REQUEST FOR PROOF OF MERCHANDISE RETURN Dear [CONTACT NAME], In reference to your letter of [DATE], we have no record of having received the merchandise you returned. In order to issue you a refund for the amount of [AMOUNT], we request that you provide us with the following information: 1. Date you returned the merchandise 2. Form of shipment (UPS, Post Office, etc.) 3. Copies of any correspondence to us in regard to returning merchandise Your cooperation in this matter will enable us to trace the parcel. About Biztree Since 2001, Biztree has helped over 12,000,000 entrepreneurs, business owners, executives and managers to start, run and grow their business more efficiently. Our Business-in-a-Box software gives you unlimited lifetime access to our entire collection of 1,800 business and legal document templates. Request for Proof of Merchandise Return Template. Received the merchandise you returned. In order to issue you a. The merchandise 2. Introduction to form templates and. That you can use in other form templates or Microsoft Office. And use its associated form template in order to function. Whether you need to write a business plan, legal contracts, proposals, business letters, board resolutions, policies, spreadsheets or any other business document, simply fill in the blanks and get the job done in minutes! To the Free Printable newsletter. (No spam, ever!) Subscribe (Free!) These business form templates are easy to download and print. Each page is available for free in DOC format. Just download it, open it in Microsoft Word (or another program that can display DOC files), and customize and print. Most of the free templates are also available in PDF format, which you can view and print with Adobe Acrobat Reader. 23 Order Form Templates Download. In order to ensure that you have the best form for sales of merchandise. Microsoft Word Purchase Order Form Template. Download Order Template - 33 free templates, samples and charts in PDF, Word, Excel and other formats. T-Shirt Order Form Template. Sales Order Template. The includes the entire collection of business form templates—all of the items on this site. Download the collection and use one business form or all of them. Also available: more including,, and.
0 Comments
Then draw and resize the shape as you need, and type the text you want into the shape. Then repeat the above steps to insert shapes and type all the process steps into the shapes. See screenshot: doc-flowchart-3. Then order the shapes based the process steps you need, and insert arrow line shape to. Description This is one of the only templates on Vertex42.com that was designed to work with only Excel 2007. The reason is that it is time consuming with Excel 2003 to create an org chart with anything other than basic rectangles and colors. This workbook contains 11 different sample org charts, including all the ones shown above and a few variations on the school and company organizational charts. I've made some of these organizational charts available as OpenOffice Calc spreadsheet templates (.ods files):,,, How to Create an Organizational Chart in Excel If you've created an organizational flow chart or other types of flow charts using PowerPoint, you probably know how frustrating it can be to constantly move around, resize, and align various blocks. But, did you know that Excel also has some of the same Drawing tools as PowerPoint and Word? Not only do you have access to the same set of tools, but take a look at the following reasons to use Excel: Why use Excel to create a Company Organization Chart? • You can create a very large organizational chart and then use the print settings to fit the entire org chart onto a single page. Trying to fit a large flow chart on a single PowerPoint slide is harder because you have to play with fonts and it's harder to scroll around on the page when you have it zoomed up. • It is very simple to align blocks of information either in columns or rows. Think of the spreadsheet grid as your 'drawing grid'. You can use drawing guides and turn on a grid in PowerPoint, but it's not as easy as using the grid in Excel. • You can resize an entire row or column of blocks in your organization chart by just resizing the row or column. By default, Autoshapes in Excel move and resize with the cells. Inserting AutoShapes and Connector Lines I hardly ever like to use Excel 2007, but when it comes to creating flow charts and diagrams, I must admit that Excel 2007 is awesome! Not only do you have more rectangular shapes available to you (various types of rounded and chamfered corners), but it is also extremely easy to add color, gradients, and shading to the blocks of your organization chart by just selecting formats from the gallery. Is this a reason to upgrade to Excel 2007? Probably not, but if you already are using 2007, then you're in luck. To help you get started, following these steps: • Go to Insert > AutoShapes and choose one of the rectangular shapes. • Click on the rectangle you just inserted. A contextual ribbon is then displayed which will allow you to select a ready-made format • To add a connector line, go to Insert > AutoShapes and choose one of the Connector objects. Tip: If you click on a connector line and the end shows a red bubble - that means it is connected to the other object. Tip: To align the blocks of the org chart to the spreadsheet's grid, hold down the ALT key as you draw or resize the Autoshapes. The Alt key causes the Autoshapes to snap to the corners and edges of the grid. Related Content. A newspaper is something that we come across not only in our societies but also in our work place, institutions and smaller communities. The power of press and words is indeed something to marvel. Newspapers and Journals have evolved over time and have a variety of layouts and formats. These Newspaper Templates have been technically and professionally designed to make your work appear more certified and easy to input your data in. Choose from a multitude of formats for your choice of template like PSD, PDF, MS Word and more and make your news more eye-catching and impressive. Blank Newspaper Templates. Free Newspaper Templates Newspapers are the heart and soul of our lives regardless of language. Institutions, work places and smaller living communities tend to take up newspaper printing to keep people informed of the local gossip and other information. These Free Newspaper Templates have been specifically designed to give each and every one of you the freedom and ability to utilize the power of press, entirely free of cost. Choose from numerous templates to your specifications along with your choice of formats such as PSD, PDF, MS Word and more to your convenience. Newspaper Ad Templates When it comes to designing a newspaper, one not only needs to understand the concept of writing, but also of designing the advertisements for each layout. These Newspaper Ad Templates have been crafted to help the budding News writer in you to place the Ad according to various styles and formats. Each of these templates has been approached on a technical and professional level to give your work the sensationalism you require. Choose from a million designs along with your preferred formats such as PSD, MS Word, PDF and more. Newspaper Article Templates There is a writer in all of us, but it takes a professional hand to get the perfection of writing newspaper articles. These Newspaper Article Templates have been designed to make your work easier to understand and appear more skilled. Designed with specific design sets and their appropriate layouts, these designs only require you to put in your data and Voila! You have your perfect Newspaper Article. Choose from a variety of template formats like PDF, MS Word, PSD and more to your convenience. Newspaper Templates For Kids It is said that the eagerness and spice for writing buds right from the childhood. By giving children the opportunity to understand the concept of newspaper writing, they can also instill the interest in understanding the layouts and styles of the design. These Newspaper Templates For Kids allow you to give them an exercise in newspaper writing and build their technical skills early on. Choose your design from millions of our templates along with your choice of format such as PDF, PSD, MS Word and more. Old Newspaper Templates It is not uncommon for older and more traditional concepts to be introduced in our daily routine. These Old Newspaper Templates have been designed to bring in the retro touch to newspaper writing. They layouts and styles have been professionally formatted leaving you to only input the data within the mentioned gridlines. Choose from a multitude of designs and give your hot news the perfect old school touch you are looking for. All these templates are available in many formats such as PSD, PDF, MS Word and more for your convenience. School Newspaper Template a school newspaper is a pallette of colors full of imaginations, it deals with spicy news and every possible thing that is loved by a teen. These newspaper are colorful and strike out the formality of having a blank and white printed newspaper. These newspapers are available in several different colors. Editable Newspaper Template Editable Newspaper Template is a simple newspaper that consists of articles which can be modified or changed as per your requirements. It includes content as well as beautiful designs which are editable in nature. Four MS Publisher documents to allow schools to. School Newspaper template pages (Publisher). Excellent tool if kids have access to Microsoft Publisher! More Newspaper Template For Microsoft Publisher 2003 images. The images can also be replaced easily. Editable newspaper is very helpful as you can make new articles using it on your own. It also supports PDF, PSD and word formats. Choose from our selection of free, downloadable business templates for Microsoft Office. We’re offering a roundup of Microsoft templates for Excel, Word and PowerPoint, all of which are customizable and easy to use. Organize your work schedule, manage projects and employees, streamline business processes, and create effective presentations. You’ll find a wide range of templates, including a sales plan, marketing calendar, business budget, SWOT analysis, invoices, meeting minutes and many more. Simply choose the template that best suits your needs, add your text or data, and print or share with your team online. These Microsoft templates are designed to help you save time while maintaining a professional appearance. Luxury 500 Office Templates for Word Excel and Powerpoint- Allowed in order to our blog site, in this particular time I will provide you with concerning 500 office templates for word excel and powerpoint. And from now on, this is actually the 1st picture: first resume example with no work experience a resume. Office templates & themes. Featured categories. Resumes and Cover Letters Calendars Flyers Planners and. Microsoft in education; Office for students. You can also create a template using Smartsheet, a spreadsheet tool with enhanced functionality, including collaboration features for communicating with clients and co-workers. Plan and Manage Your Work With Smartsheet's Templates Smartsheet is a powerful management tool in a familiar spreadsheet layout. The web application is completely customizable and shareable with an infinite number of collaborators, so you can build any template to fit your business needs. However, Smartsheet also has a variety of templates for more specific business use cases, and can help you to simplify and streamline the way you plan and manage your work. For instance, Smartsheet’s Project with Schedule & Budget Variance template allows you to track project and budget performance in one easy-to-use sheet. The template includes status summary, budget and schedule variance, and allows you to compare estimated and actual labor, material, and other project costs. You can also view your sheet in Gantt, calendar, or Card View for a more visual overview of the multiple pieces of your project. Smartsheet’s Project with Schedule & Budget Variance template Other useful business templates include the Monthly Budget Tracker template, which helps you stick to your spending and savings goals, and the Sales Pipeline by Probability template which allows you to view key info on each sales opportunity (Smartsheet also offers sales pipeline templates by summary, representative, or stage). Use the Employee Review and Performance template to set employee objectives and track feedback, or stay on top of all your business expenses with the Expense Report template. You can find a complete listing of all templates by Smartsheet in the. Smartsheet helps make collaboration simple with anytime, anywhere access. Attach relevant documents directly to rows in your sheet, and add notes about a task in the Comments section. Remember, all of these templates are completely customizable, so you can modify them to fit your project needs. If you found this post helpful, visit our to get more marketing tips and templates. 500 microsoft office templates powerpoint free. Pcs, office delivers the tools to get work done.welcome to powerpoint powerpoint.this is a free compatible orange. Try Microsoft Edge A fast and secure browser that's. No results; 0. Office Buy Office 365. Featured Word Templates. Templates for ms office is magic and easy-to-use app help you easier to create Microsoft office 365 documents in your windows 10. Complete with the best documents, guides and templates available for Microsoft Office! Features: - Create Word, Excel and PowerPoint documents. - Provide professional templates for Word, Excel and Power point. - Keep track all changes of online documents and automatic update on local. - Browse free online templates to create beautiful documents. - Create and print custom labels and PDFs. - Work with documents while on the go. - Enjoy the freedom that comes with online and mobile editing. - Add charts, pictures, animations and effects. Sign-in sheet. Use this template to create a sign-in sheet for classes, workshops, meetings, or other events. Helpful for creating a mailing list. Download Edit in Browser. Sign-in sheet. 7 Free Sign In Sheet Templates. Download sign in sheet templates here. Visitor Sign In. If you were looking for Microsoft word ticket template because this. • • • • • • • Getting volunteers for your cause can be a challenging task. Recruiting the right people and convincing them to volunteer their time and energy, is important for your campaign to thrive. After all, its success means the success of your organization’s cause, which would in turn benefit people in your community, school, or workplace. To help get you started, Microsoft Office has a Volunteer Sign Up Sheet Template for Word that you can use to get people to sign up for your cause. Whether you have a clean-up drive, call for recycling, packing and giving out relief goods after a disaster, teaching street children, or having a blood drive, this Volunteer Sign Up Sheet will be a helpful tool. This Volunteer Sign Up Sheet Template has a header in big, bold letters that say, “I Want You To Volunteer”. This invites anyone to sign up and lets them know immediately that you need them for a cause. Underneath is a list where people’s names and contact information can be filled in. The list have adequate space for people to write their names and information by hand. In this Volunteer Sign Up Sheet, volunteers can write their Name, Home Phone Number, Cellphone Number, Email Address, Area of Expertise or Interest, and Days or Times Available. This helps you keep a good, detailed record of volunteers for instances when you have other volunteer activities in the future. Knowing your volunteers’ activities would make it easy for you to assign them to tasks or programs where they can excel in, or use their skills, helping you make your campaign more successful. Having a record of their availability would also help you determine the best times to conduct your programs, or schedule activities where your volunteers can attend and fully participate in. You can also use this Volunteer Sign Up Sheet if you plan to recruit your volunteers online. You can email this sheet to your friends, colleagues, and family members. You can also upload this on your organization’s website for people to sign in, or they can print it for themselves and encourage their friends and family as well. Related Posts • If you need a billing statement template for billing purposes then this free billing statement template for Word can be helpful. It is a free • Some occupations can be hazardous or make you prone to accidents, which may render you to be unable to function well, be absent from work, • A receipt is not an unusual thing in any business. As a trading or financial entity, you may have received or issued receipts. A receipt • Free Balance Sheet Template is a free spreadsheet template for Excel that you can download to make a balance sheet. You can download free Balance • Evicting a tenant is one of the most unfortunate parts of being a landlord. Eviction is usually a time-consuming and sometimes costly process that starts. If you haven’t already,. Read on to learn how to use the template to make your own database and start using it to help run your business. In this article Start the database for the first time When you first create the Goods database, some sample data is included in the database so that you can get an idea of what types of data each form or report contains. A dialog box appears which allows you to choose whether to keep the sample data or delete it so that you can begin entering your own data. Click this button to open the database and work with the sample data. This will populate the Goods database with data from the fictional company Northwind Traders. Click this button to delete the sample data so you can begin entering your own. This also prevents this dialog box from appearing the next time you start the database. Clear this check box to prevent the dialog box from appearing next time you start the database. Note: All fields and controls in the Goods template that display currency data use a dollar sign ($) as the currency symbol. If your locale uses a different currency symbol, you should consider adjusting the affected fields and controls before you remove the sample data. For more information, see the See Also section. Getting started: Add existing data to your Goods database The Getting Started tab includes links to videos and other resources that will help you begin using the database quickly. In addition to providing assistance for using the database, the Getting Started tab contains additional tabs that let you set up the database for its initial use. • When you are finished viewing the information on the Welcome tab, click Next. Enter your company information On the Company Info sub-tab, you can enter information about your company, such as name, location, phone, and email address. The company name you enter will be displayed at the top of the database “Main” screen (where you see “Northwind Traders” in the preceding illustration). Your company information will also be displayed on invoices and other reports created by the database. • Type in your company’s information into the boxes, click Save and Apply Company Settings, and then click Next. Note: It is not necessary to enter all of your data by using the Getting Started sub-tabs. Most of the information that you can enter on these sub-tabs can also be entered on the main tabs, such as Products, Orders, and Employees. However, these sub-tabs give you a convenient way to get started entering data. Enter employee information On the Employees sub-tab, you can begin adding employees to the database. This will help you track who was the salesperson on each order, who submitted an order, and so on. If you are a sole proprietor, the database will work fine with just a single employee. • Type each employee’s information into the datasheet, and then click Next. Note: You can also view, edit, and add employees on the main Employees tab. Enter products, categories, and suppliers On the Products sub-tab, you can begin adding products to the database. These are the products that your business sells. You can also edit the lists of categories and suppliers on this sub-tab. • Type each product’s information into the datasheet, and then click Next. • Alternatively, click New Product to open the Product Detail form, into which you can enter the product information. • Click Edit Categories or Edit Suppliers to edit the lists of categories and suppliers. • When you are finished editing product information, click Next. Note: You can also view and edit inventory levels, categories, and suppliers on the corresponding sub-tabs of the main Products tab. Enter orders If you already have some orders on hand, you can enter basic information about them on the Orders sub-tab. • For each order, enter the information you have, such as Order Date, the employee who took the order and the customer. • If you enter a customer that has not yet been entered into the database, Access prompts you to enter the new customer. Click Yes, and then fill in the information you have. When you close the datasheet, the customer will be available in the Customer drop-down list. • When you are finished editing order information, click Next. Note: You can also view and edit inventory levels, categories, and suppliers on the corresponding sub-tabs of the main Products tab. Dashboard: View orders and purchasing status The Dashboard tab provides a convenient place to view active orders, as well as any products that are running low on inventory and need to be reordered. You can also edit the information that you see on this tab—just click in the cell that you want to edit and begin typing. To enter detailed information about new customer orders or purchase orders, click New Customer Order or New Purchase Order, and then fill in the form that appears. PARTS INVENTORY SHEET| Parts inventory excel template,Provided by Jaxworks Microsoft Partner. Templates Support Buy Office 365. Personal Inventory Excel. Household organizer Excel. Microsoft in education; Office for students. A blog for listing new and interesting Excel templates for. Download a Bill of Materials template to create a parts list for. Excel Templates; Microsoft.com. Products: Manage products, inventory, and suppliers The Products tab is where you manage all aspects of the products you sell, such as: • Detailed product information • Inventory levels • Discontinued products • Product categories • Suppliers of your products When you click the Products tab, it initially displays a datasheet listing of all products currently being sold by your business. You can enter and edit product information directly into the datasheet. • The Product Code field can contain any combination of text and numbers, as long as you use a unique value for each product. • To add a new product, type it into the datasheet or click New Product to open the Product Detail form. • To edit the details of an existing product, click the product code in the datasheet. The Product Detail form appears, in which you can view and edit the information about the product. Manage inventory The Goods database template provides automatic tracking of inventory; whenever an order is shipped, or new products are purchased, the database automatically updates the inventory so that you know how much stock you have on hand at any time. The database will also display products that need to be reordered, based on thresholds you specify. On the Products tab, click Inventory Levels. This datasheet displays current inventory levels and other thresholds for each product as follows: • On Hand The number of items that you currently have in stock. • Allocated The number of items that have been ordered by customers, but not yet shipped. • Available The difference between the number of items on hand and the number allocated. • Shrinkage This is the number of items that have been lost due to damage, spoilage, loss, and so on. • On Order The number of items that you have ordered to replenish stock, but which have not yet been received. • Current Level The number of available items minus the number of items on backorder, plus the number of items currently on order. • Target Level The number of items that you want to have on hand to accommodate the predicted level of orders. • Below Target The current number of items at which you are below your target level. • Purchase Click the Purchaselink to enter a new purchase order. For more information about purchasing, see the section. Check to see which products need restocking To see at a glance which products need to be ordered, on the Products tab, click Needs Restocking. This view is the same as the Inventory Levels datasheet, except that the records have been filtered to only those that are at or below their specified reorder level. To quickly reorder a product, scroll to the right and click the Purchase link. For more information about purchasing, see the section. View discontinued products On the Products tab, click Discontinued Products to view a list of products that have been marked as discontinued. • To reinstate a discontinued product, click its product code, and then in the Product Detail form, clear the Discontinued check box. Create categories for products Categorizing your products helps you to organize them on forms and reports. On the Products tab, click Categories to customize your list of categories. Enter each category on its own line. • To delete a category, click the gray box just to the left of the ID, and then press DELETE. Note: Access prevents you from deleting any categories that are connected to products. For example, you cannot delete the “Beverages” category if there are any products that are still assigned to that category. Manage supplier information Suppliers are the businesses and individuals from whom you purchase your inventory. To keep track of your suppliers’ contact information, on the Products tab, click Suppliers. • Click an ID to open an existing supplier record and edit their information. • Click (New) at the bottom of the ID column to enter a new supplier, or just begin typing on the last row of the datasheet. • To delete a supplier, click the gray box just to the left of the ID, and then press DELETE. Note: Access prevents you from deleting any suppliers that are connected to products. For example, you cannot delete Supplier X if any products are still listed as coming from that supplier. Delete the supplier’s products first, and then delete the supplier. Orders: Manage customer orders The Orders tab is where you go to enter new orders, view orders by status, and track information about customers and shippers. Enter a new order When a new customer order comes in, you use the Customer Order form to enter the details. • On the Orders tab, click New Order. Alternatively, on the Dashboard tab, click New Customer Order. The Customer Order Form appears. • Select a customer from the drop-down list. If this is a new customer, click New, fill in the customer’s information on the Customer Details form, and then click Save and Close. • Fill in the information on the Customer Order Form, being sure to also fill in the fields on the Shipping Information and the Payment Information tabs. • When you have finished filling out the order, click Save & Close. View and manage orders by status Each order moves through several different statuses, which are automatically updated as you perform the tasks of entering, invoicing, and shipping an order: • New • Invoiced • Shipped • Completed When you first click the Orders tab, the datasheet displays all active orders (all those with a status other than Completed). After an order has been taken, the process flow is as follows: Create an invoice When an order is first entered, it is marked as New. The next step with a new order is to send an invoice. To invoice an order: • On the Orders tab, click Need Invoicing to see all orders that are ready for invoicing. • Double-click the order that you want to invoice. • In the Customer Order Form, check that all the information is correct. • On the Shipping Information tab, verify that a shipper has been selected in the Ship Via box. • Click Invoice Order, and then click Yes to confirm. The Goods database marks the order as Invoiced, and displays an invoice for you to print. Enter a customer payment Some businesses require payment before an order can be shipped. Others allow shipment to occur before payment is received. The Goods database allows for either scenario. To enter a payment: • On the Orders tab, click Awaiting Payment. Note: This filters the datasheet to show orders that are marked as Invoiced or Shipped. If your business requires payment before shipping, and you see an order marked as Shipped in this view, you will probably want to investigate why the order was shipped before payment was received. • Double-click the order for which you want to enter a payment. • In the Customer Order Form, click the Payment Information tab. • Select a value from the Payment Type list, and fill in any other payment information you have. • Do one of the following: • If the order has not yet been shipped, and you want to ship the order now, click Ship Order. • If the order has already been marked as Shipped and you now consider the order complete, click Mark as Completed to complete the order. • To close the Customer Order Form without making any further changes, click Save & Close. Ship an order As mentioned in the previous section, some businesses require payment before an order can be shipped, whereas others allow shipment to occur before payment is received. Therefore, the Goods database does not enforce a rule requiring payment before shipping. To ship an order: • On the Orders tab, click Ready To Ship to see all orders that have been marked as Invoiced. • Double-click the order that you want to ship. • If your business requires payment before an order can be shipped, click the Payment Information tab and verify that payment information has been entered. • Click Ship Order, and then click OK on the confirmation message. • Do one of the following: • If you now consider the order complete, click Mark as Completed to complete the order. • To close the Customer Order Form without making any further changes, click Save & Close. Mark an order as Completed After an order has been shipped and payment has been received, you can mark it as Completed. • Click the Orders tab, and then scan the list for any order that has dates in both the Shipped Date and Payment Date columns. This indicates that an order has been shipped and that payment has been received. • Double-click the order that you want to mark as Completed. • In the Customer Order Form, click Mark as Completed, and then click OK on the confirmation message. • Click Save & Close. Marking an order as Completed removes it from most of the views in the database. However, you can still view completed orders by clicking the Orders tab, and then clicking Completed Orders. Order status quick reference The following table provides a quick reference for which orders are displayed in each view, as well as the actions you can take on those orders: If you click and the order status is you can perform the following task(s) on the Customer Order form: Notes: Orders New Invoice Order A shipping company must be specified before order can be invoiced. Orders Invoiced View Invoice or Ship Order Orders Shipped View Invoice or Mark as Completed Need Invoicing New Invoice Order A shipping company must be specified before order can be invoiced. Ready to Ship Invoiced View Invoice, Ship Order Awaiting Payment Invoiced View Invoice, Ship Order or Mark as Completed Awaiting Payment Shipped View Invoice, Mark as Completed Shipping and payment information must be entered before order can be marked as completed. Completed Orders Completed None Manage customer information The Goods database stores contact information about all your customers. You can add new customers as part of the process of, or you can manage your customers by using the following procedure: • On the Orders tab, click Customers. • To edit an existing customer, click in the field you want to edit and then start typing. • To add a new customer, click (New) at the bottom of the ID column, or just begin typing in the last row of the datasheet. Manage shipper information The Goods database stores contact information about all your shippers. You can manage your customers by using the following procedure: • On the Orders tab, click Shippers. • To edit an existing shipper, click in the field you want to edit and then start typing. • To add a new shipper, click (New) at the bottom of the ID column, or just begin typing in the last row of the datasheet. Purchases: Restock your inventory If your business obtains its products from wholesalers or other businesses, it is necessary to make purchases to restock inventory. The Goods database lets you create and track purchase orders, and automatically updates inventory numbers as purchased items are received. All of these tasks can be done from the Purchases tab: Create a purchase order Creating a purchase order is the first step in buying new inventory. • On the Purchases tab, click New Purchase Order. • In the Purchase Order form, select a supplier. If you are ordering from a new supplier, click New, fill out the information in the Supplier Details form, and then click Save & Close. • On the Purchase Details tab, select the products that you want to order, and enter quantities for each. • If the purchase order is ready to be submitted, click Submit Order. Otherwise, to keep the purchase order in New status so that you can make changes to it before submitting it, click Save & Close. The database creates the purchase order and marks it as New. Submit a purchase order for purchasing The next step for a new purchase order is to submit it for purchasing. This step updates the inventory totals so that you know how much stock is currently on order. • On the Purchases tab, click Awaiting Approval. • Double-click a purchase order to open the Purchase Order form. • Check that the products, quantities, and prices are accurate, and then click Submit Order. The database marks the purchase order as Submitted and updates the On Order quantity for the products being ordered. If an order is large enough to put a product’s inventory above its Reorder Level setting, the product is removed from the list. Receive inventory When new inventory is received, the next step is to mark it as such. This updates the inventory totals so that you know how much inventory is on hand. • On the Purchases tab, click Inventory Receiving. • Double-click a purchase order to open the Purchase Order form. • On the Purchase Order form, click the Inventory Receiving tab. • For each product received, select the Post To Inventory check box. • If all items have been received and payment information has been entered on the Payment Information tab, you can click Complete Order to mark the purchase order as Completed. • If some items on the purchase order have not been received yet, click Save & Close. You cannot complete the order until all items have been received and posted to inventory. Complete a purchase order If all the items on a purchase order have been posted to inventory, and payment information has been entered, you can mark the purchase order as Completed. This removes the purchase order from the active purchase order lists, and moves it to the Completed Purchases list so that you can refer to it later if needed. To mark a purchase order as Completed: • On the Purchases tab, click Inventory Receiving. • Double-click a purchase order to open the Purchase Order form. • Click the Payment Information tab and make sure that the correct payment information has been entered. • On the Purchase Order form, click Complete Order. Manage supplier information Suppliers are the businesses and individuals from whom you purchase your inventory. To keep track of your suppliers’ contact information, on the Purchases tab, click Suppliers. • Click an ID to open an existing supplier record and edit their information. • Click (New) at the bottom of the ID column to enter a new supplier, or just begin typing on the last row of the datasheet. To delete a supplier, click the gray box (record selector) just to the left of the ID, and then press DELETE. Note: Access prevents you from deleting any suppliers that are connected to products. For example, you cannot delete Supplier X if any products are still listed as coming from that supplier. Report Center: View and print reports The Goods database template includes six reports, which you can view and print by clicking the Report Center tab: To preview a report: • Under Select a Report, click the report that you want to view. Access displays the report in the preview pane. Some reports let you customize filters and grouping options at the top of the preview pane. To print a report: • Click Open in New Tab, and then on the File tab, click Print, and select the print options that you want. Advanced: Manage customers, employees, suppliers, categories, and shippers The Advanced tab provides a convenient place to manage the following lists: • Customers • Employees • Suppliers • Categories • Shippers Each list is displayed as a datasheet, where it is easier to spot inconsistencies and make bulk changes to data. Next Steps As you begin to use the Goods database to manage your business, you will most likely think of new ways in which you want to query or filter your data. You may also discover that you want to modify the database to better suit your needs. The links in this section take you to more information about the typical tasks and modifications that you can do. • For information about finding, filtering, or querying data in Access, see the following: • • • • For more detailed information about creating new database objects, see the following: • • • • • • And finally, an important article about safeguarding your data. Contents • • • • • • • • • • • Overview Free Microsoft Office Tutorials Adding a Print Button: Appendix added 14/1/15 (end of article) This is a VBA Excel Phone list series that will develop this fantastic phone contact interface. Everything is managed from the userform. Template with the userform can be downloaded below. The code for the Excel Phone Book will be added as we go through the tutorials. This project will work with Excel 2003 / 2007 / 2010. Goal: Develop skills in application development. Here is a image of the hidden database for the Excel Phone Book. What will we learn? Recording macros Working with variables Functions /IF / SORT / OFFSET Variable advanced filters Copy and paste without selecting Application logic Download the free template to get you started. Note: This is not the completed project it is a template to help with the project. Watch this video to seen the features of the Excel Phone Book in action. Online PC Learning is committed to providing free o ffice tutorials Simply the Best Excel Phone Book – Contact Manager: Part 2 Free Microsoft Office Tutorials Simply the Best Excel Phone Book – Part2 Video 2 – Excel Phone Book Modifying the template The template is formatted for you completely. I contains 2 worksheets. Name them what ever you want. It will not effect the running of the phone book. I have left the navigation buttons with the hyperlinks attached and a small piece of code to open the userform. If you were to open the Name Manager( Formula tab / Name manager) here are the named ranges included in the template. ID =phonelist!$A$1 This is for the hyperlink to the database outdata =OFFSET(phonelist!$N$9,0,0,COUNTA(phonelist!$N$9:$N$10000),7) This is a dynamic named range to pick up the filtered data and add it to the userform. Please Note: If you copy and paste these formulas Excel may view them as text and add =' formula '. If this occurs type the named range in or remove the double quotes after you paste. Start =Interface!$A$1 This is for the hyperlink to the Interface When ever you run an advanced filter Microsoft Excel adds the named ranges for the Criteria and the Extract. Don't worry about these. In this tutorial I will show you how to run and record the advanced filter and then to run the macro from a keyboard shortcut. Hi Under File/New/Templates - this is where we store all our Word templates. Can you add a shortcut to your desktop for one of these templates? Thanks Donna. Try Microsoft Edge A fast and secure browser that's designed for Windows. No results; 0. Office Buy Office 365. Free download excel 2010 address book template Files at Software Informer. This software offers a solution for users who want to create mailing labels. Here is the basic breakdown of how advanced filters work. Firstly, where do we locate the advanced filter tab? On the ribbon click the Data tab and then click Advanced. See illustration below Dialog box options for advanced filters 1) When you click the advanced button a dialogue box appears giving you the several options let’s have a look at what those options are. Under the category Action you will notice 2 radio buttons. If you wish to filter the data set itself or in place then click the top button. 2) If you wish to filter to another location whether that be on the same worksheet or and other worksheet you would click Copy to another location. It is very important to remember that if you wish to have the data filtered to another sheet then you must start this process from that sheet. 3) You now have three boxes i) List range ii) Criteria range iii) Copy to 4) To set these three ranges you need to first click inside the box until you see your cursor inside the box. That tells Microsoft Excel that that is the area you wish to now edit. 5) Enter the range manually or click the red arrow and scroll over the range for that particular section. 6) If you wish only to filter unique records and this can be a very valuable asset if you are looking for specific data in large data sets then clicks the button unique records. The List range The list range must include the heading along with all of the data. There should not be any blank rows in your data. And it is best to surround the data set with blank columns and rows so that Microsoft Excel can recognise this as a data list. The Criteria range. The criteria range should include both the header and that the criteria with no spaces. It is possible to filter with multiple criteria and with operators such as greater than >/ less than parameters for your criteria. You can also filter between two sets of criteria such as greater than> /and less than. Here are the 3 steps for this project's advanced filter Record the advanced filter for the Excel Phone Book Now lets run the advanced filter and record it as we go. Click on the Developer tab. If you can not see the Developer tab click File/ Options / Customise the ribbon /in the right hand tab tick the box next to Developer. Now click Record Macro and the macro dialog box will appear. Give the macro a name (one word or multiple words joined with underscores) make sure theStore macro in: is This Workbook. Push the cap lock on your keyboard and in Shortcut Key: type a letter choose a letter,let's say A. Now we can run the macro by holding down Ctrl+ Shift+A. This makes testing easy. Here is your challenge. Run the advanced filter and then stop recording the macro. Now push Ctrl+ Shift+A to run the advanced filter. Test it by changing the criteria header and criteria. This is what the recorded macro should look like Sub Advanced_Filter() ' ' Advanced_Filter Macro ' ' Keyboard Shortcut: Ctrl+Shift+A ' Range('B8:H204').AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _ 'phonelist!Criteria'), CopyToRange:=Range('phonelist!Extract'), Unique:= _ False End Sub The Userform The userform is also fully formatted with the controls named appropriate to the code that will be added as we go. If it is for example a textbox for searching I would name it txtSearch a command button to close the form would be cmdClose. This will make the code easier to read then TextBox1 or CommandButton1. With the ListBox it is important to make sure that the Properties are set for BoundColumns 1 ColumnCount 6 ColumnWidth 80pt;80pt;80pt;80pt;80pt;80pt(change the sizes to suit the widths) Online PC Learning is committed to providing free o ffice tutorials Simply the Best Phone Book – Contact Manager: Part 3 Adding the advanced filter to the userform. Free Microsoft Office Tutorials Simply the Best Excel Phone Book – Part3 Video 3 – Excel Phone Book. Adding the advanced filter to the userform. Part 3: Adding the advanced filter to the Userform. How are we going to have the data in our database referenced as it grows and shrinks? There are 3 ways that I know of to do this. • Use a dynamic named range • Set a static named range every time we run the procedure. • Use CurrentRegion It is possible in some situations that the database may be very large so I would not recommend a dynamic named range. To set a static named range as the procedure is run would work but by far the simplest and most effective method is to use Current Region. To have a brief look at how this works: click anywhere in your data then on the Home tab select Find and Select on the right hand side then choose go to Special and tick the Current Region option button. If you were to record this action in code you would see this: Sub Macro1() Selection.CurrentRegion.Select End Sub Let’s add this to our Advanced filter module. We will set a variable for the sheet name and add CurrentRegion Set DataSH = Sheet1 DataSH.Range('B8').CurrentRegion. AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _ 'phonelist!Criteria'), CopyToRange:=Range('phonelist!Extract'), Unique:= _ False Adding the code to the userform We can now take this code and add it straight in to the PhoneList Userform. Press Alt+F11 to open the VBE and double click on the Userform. Double click on the command button Get Contacts and paste your code in to the Private Sub cmdContact_Click() Put the code here End Sub Make it flexible Now we want to be able to change the advanced filter criteria from the Userform so we will have full filtering control. First we need to add the criteria headers to the ComboBox (cboSelect) Open the Userform in the VBE and right click the userform and choose View Code. O the top right hand corner click the drop down arrow for the events associated with the Userform, select “Initialze” Add this code. Private Sub UserForm_Initialize() Me.cboSelect.List = WorksheetFunction.Transpose(Sheet1.Range('B8:G8')) End Sub This will add the headers form the database (CriteriaHeaders) to the ComboBox. Now lets set 2 variables for the criteria header and the criteria. Under “Set DataSH = Sheet1” add the code below DataSH.Range('L8') = Me.cboSelect.Value DataSH.Range('L9') = Me.txtSearch.Text Adding data to the ListBox in the Excel Phone Book To add our filtered data to the Userform add the code shown here. This code says add the dynamic range “outdata” as the RowSource for the listbox. The range “outdata” is included in your template. ListBox1.RowSource = Sheet1.Range('outdata').Address(external:=True) I have also put in some error handling so now your completed Get Contact procedure will look like this. Private Sub cmdDelete_Click() On Error GoTo cmdDelete_Click_Error If txtSurname = ' Then Call MsgBox('Double click the contact so it can be deleted', vbInformation, 'Delete Contact') Exit Sub End If Select Case MsgBox('You are about to delete a contact.' _ & vbCrLf & 'Do you want to proceed?' Method 1 This method will automatically print the named range “outdata” 1. Add a command button to your form and name it cmdPrint 2. Double-click the command button and add this code Sheet1.Range('outdata').PrintOut Method 2 This method will will show the print dialogue box and will print the named range “outdata” 3. Add a command button to your form and name it cmdPrint 4. Double-click the command button and add this code Sheet1.Select Sheet1.Range('outdata').Select Sheet1.PageSetup.PrintArea = 'outdata' Application.Dialogs(xlDialogPrint).Show Note: with both of these methods you will need to initially set the page break widths. You will only need to do this the first time if the print out is on more than one page. Hi Trevor, Excellent tutorials! Very easy to follow. Really happy you have made this available. One question, how can one edit the order in which the TAB or Enter button moves about the form? For example, when adding a New Contact, after hitting TAB / Enter in the Surname field, the cursor moves to the Mobile field, then after that is moves to Address Instead, it would be great to have the TAB/Enter move in a direct line left to right, then wrap to the second line, again moving left to right. Like a word processor or typewriter:) Kind Regards, Sophie •. Greetings Afzal, Thanks for the positive feedback. Really do appreciate you taking the time to comment. With regard to your question on tables and dynamic named ranges. There are four methods that I consider in making our range dynamic. Dynamic named ranges (if the dataset is not going to be too long this is a great and simple method) presents no problem in code. Depending on the dataset that is available this is very good for a lot of data. It is particularly good if the user will have no access to the data range. I use tables particularly in small personal workbook’s or where I need to pivot the data. However there are some limitations with tables. When it comes to protecting your application I often like to protect the headers but allow access to the data with tables this becomes a problem. I also think there are limitations with tables in shared workbooks which I often use. Having said that there are a couple of the tutorials I’ve put out there that use tables quite extensively they are quick and easy and a great feature in Microsoft Excel. Creating static named ranges on the fly. With larger data sets this is my preferred method for making a range dynamic when data is added you simply reset the static named range. Another consideration with tables that I have is that many who watch these tutorials are still using Microsoft 2003. I like to try to provide projects that can be used across platforms from 2003 to 2013 if possible. Another consideration with tables that I have is that many who watch these tutorials are still using Microsoft 2003. I like to try to provide projects that can be used across version from 2003 to 2013 if possible. Thanks very much for watching the tutorials. I appreciate your feedback very much Kind regards and best wishes Trevor Easton •. Good morning Trevor. Wow what a fantastic tutorial. I used to do quite a lot of work on excel and got board after a few years, however after having watched some of your tutorials you have inspired me to go back to it. Where I thought I had got as far as I could you have shown me new ways to make my work even more presentable. I have recently re-written a program for my company where uses were lost and didn't understand how to use it. I have adapted what you have taught us in the 'Simply the best phone book' and now they will be distributing the program throughout the business as a productivity time saving tool. Thank you again for your time in sharing your knowledge. I will try to pass this knowledge on to other enthusiasts alike. All the best wishes Cliff •. High Dave, There are a number of ways to achieve this. When you open the VBA editor the button at the top next to the big red X is a Restore Down button.This will allow the VBA editor to float. Another and more effective way is on the View tab choose the command New Window in that will open your application in 2 windows.All you then need to do is open your VBA editor in the second window. This is the best and easiest option. That do not forget that you are actually working now on to Windows and you will need to close one before you save your file. Sorry for the delay in responding to your question. Best wishes and kind regards Trevor Easton •. Hi Trevor I want to thank you for your help you have given me on the phone book project, I have now added the extra columns and modified in the way that I needed. I find your site very helpful with lots of video tutorials and cant wait for your next projects to be added ( do you know what they will be? ) Do you have project for recruitment management i.e. Tracking all CV's that come into a company?. You mentioned in the phone book video 5 that there is some code on your site for protecting the book, where about is that. Thank you once again •. Hi Mike, I will have a look at adding a short section to the end of the project with code and instructions for automatic protection of the project, I will send you an email when this is done. There are 2 projects that HR departments have used. Sick Leave Tracker Staff Training Manager ( Competency tracker) I will have a look at the CV Tracking and see if I thank it would have broad enough appeal for a project. 3 future projects are on the future projects page of the website with videos on the home page at the top. Best Wishes Trev •. Hi Istvan, The best way that I know to learn is through project development. This certainly has accelerated my learning curve. The projects on Online PC Learning are presented a basic as possible to accommodate easy learning. Business applications would be far more complicated and and of course expensive to develop as you need to factor in specific customer needs and end user training. They are not suited to a progressive learning curve. The acticle on Developing Bullet Proof applications may be of help. Best wishes Trev •. Good day Trev, I have worked on the PhoneBook exercise and tailor designed it to my specific needs. Thank you very much this indeed is a masterpiece of a document. Just two challenges though if may 1. When running the file after having created it, should i search for a name which does not exist in my database, I get an Error 'debug/end' message. The file that i have now created has 12 columns instead of the normal 6 as you have it on your phone book exercise, i have changed the column count on my 'properties' under the developer however when running the program i do not see all 12 of my columns. I wish do add a 'print Button' on my file, how would I go about doing this if at all it is possible? Thanking you in advance, Kind regards Mushtaq •. Hi Mustang, I am glad the project if of benefit. Assuming you have used the code on the website which contains some basic error handling then your VBA editor error options is not set correctly. Make sure that your Excel application has the right options checked to enable you to deal with errors properly.To access this dialogue box in the VBA editor choose Options are from the Tools menu and then click on the General tab.Notice the section here for Error Trapping. Set the option Break on Unhandled Errors. I would suggest that you read the resent article on error handling on the website VBA for Beginners series. You need to not only add the extra columns and set the number in the properties but also set the widths for the extra columns. E.g 40pt;35pt; etc 3. Contact me and I will send you a sample file to show how to create a print option. Best Wishes Trev •. Trev, While I am also enjoying your later work, this application is easier for me to understand at my beginner level. I am using it on what is a big project for me, and as you like to say, it is working a treat! I can't tell you how much I appreciate your sharing your hard work. The few bucks I spent buying this completed project along with your manual not only saved me tons of hours, but I never would have been able to figure this stuff out without it no matter how much time I spent. You are THE MAN!!! Cheers, Kevin •. Hi I have one more question, im using this phone book as my music files all working as it should, I was wondering if I could ad an hyper link to play the file, ie when I dubble click on the name the the information goes to the boxes as it should and if I want to play I press a button and plays that file ( the button I need to add ) is this possible. I know how to add hyper link in excel cells but not in VBA, not sure if this is possible or not, could you shed a little light on this for me Thank you •. Hi Mike, You certainly have found some uses for this application.Again this is not something that I have done but I guess the first thing that needs to be considered is where did you want to play the file? In the application or in Windows media player? It would need to be linked and not embedded. There are some very nice features available in Windows media player for playlists et cetera have you have a look at these? I really think that we may be getting outside the intended purpose for Microsoft Excel. There are other applications that are designed to store and play media files.Probably the best thing to do is have a search around the web and see if anybody else has done this. Maybe you can get some ideas. There is a very good tutorial on the website about embedding YouTube videos in Microsoft Excel. I demonstrate the three methods to do this in this article. Best wishes Trevor •. Hi Mike, This feature is a default feature in Microsoft Access 2010 and 2013. If you wish to do something like this in Microsoft Excel I think it probably would be feasible. You would need to add another column to your database and in that column you would need to have the name of the picture and the extension. The folder path would be established as in inserting a photo in a user form project. When you double clicked me staff member in the listbox you would need to run some code that would locate the folder path and the name of the file name in the database and assign it to the image container. Having said that you would need also run some code that would check to see if a picture was available and also to cope with the fact that someone may have deleted a picture or moved it. This would generate an error. This is not something I have done so I could not recommend it but maybe in the future I could have play around with it. Hi Trevor, Thank you very much for your excellent tutorials, they have helped me so much. I have created your phone book and it works perfect. Question regarding the Extract and Criteria dynamic ranges on sheet1. Is it possible to have more instances of this functionality In one workbook? Of course with different range names. Let's say Extractpromo and Criteriapromo on sheet2 The problem I'm facing is when i run my second userform. It renames my dynamic ranges on sheet 2 to Extract and Criteria. If it is possible it must mean I messed up somewhere. Thanks in advance! Hi Mike, When an advanced filter runs it creates 2 named ranges one for the extract and one for the criteria in addition to your dynamic named ranges. These change with the data presented. They will not effect the dynamic named ranges. To view a dynamic named ranges you need to go to the name manager as they is a formulas. You will see the extract and criteria ranges as static in the name box at the top left of the sheet. You will see all of the named ranges in the name manager. You can run multiple criteria blocks or multiple criteria with in the criteria range. It is extremely versatile. Best wishes Trev •. Hi Trev, Thanks for taking the time to reply. The only problem I have now is running two advanced filters within the same workbook. I'll explain the scenario. I have 2 Userforms in my workbook. Userform1 is your PhoneBook with the date in Sheet1. Userform2 is my own creating but using your method, with the data in Sheet2. I can get both Userforms to work perfectly on their own. The problem is getting Userform1 and Userform2 to work at the same time. The Criteria and Extract range does not seem to switch between Sheet1 and Sheet2. When I check the Name Manager it shows Criteria and Extract refering to Sheet1. Is there a way to point the Criteria and Extract to the right sheet depending on which Userform is Initialized? Thanks for any help. The reason why I want to do this method, is that if you click on Look Up Code and the search criteria box is blank, it still brings out the entire list of data – this will be handy for my users if they do not know what to search for. In your other projects you have used a different method to look up data (Staff Database) in this userform if the search criteria box is empty it does not return any data in the listbox. Cheers, Mike •. Hi Mike, You can have the two user forms active at the same time if you set their properties ShowModal = False. This will allow you to interact with other objects including user forms. This is not something I would generally do. It is better to call the second user form from the first and then hide or unload the first user form and then add the same options to the second user form. You can explicitly reference the criteria, copyto range and extract range in your advanced filters. Here is an example below here I have used the sheet codename not the sheet name. Sheet4.Range('C8').CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= Sheet4.Range( _ 'BI6:BK8'), CopyToRange:= Sheet4.Range('BM8:BP8'), Unique:=False Another option you might consider is changing the criteria in code. By the use of operators such as the wildcard you can make your search much more explicit and give the user the option to choose whether they want to search containing or perform an exact search. Best wishes Trevor •. Hello Trevor, Your tutorials are excellent. I have learned so much about excel and VBA working through the phone book project. Thank you so much for all your hard work on this website. After working through the project as suggested everything works perfectly but I seemed to have run into a problem with my modified project with editing, deleting and the double click command. I would be very grateful if you could just point me in the right direction to solving this error message that appears upon double-clicking the contact: 'Error- (Could not get column property. Invalid argument.' The info is brought down into the appropriate text boxes but I cannot edit or delete. Cheers and Happy New Year! Hi Trevor I've completed the tour and have also downloaded the full code. My modifications worked fine to begin with, but I ran into problems when adding extra columns. I want to ad 3 more columns and did the setup in the PhoneList form, adding the ColumnCount to 9. Added the ColumnWidths for the extra columns. Ajusted the code in various places (since the ID column had moved) and so on. But it did not work. I can add a new contact including all the new fields but only 7 will show. I can see in the 'database' that they get to the right places. I can even see that the listbox makes room for them all. When I doubleclick on a contact I get a 'Could not get the Column property. Invalid argument' error from Excell. But it fills the fiels regardeless. When I try to edit I get the 'Fields not complete' error. I went back to your code (the full template) and added just 1 column. Did all of the above modifications but still same result. Do you have any sugestions? Hi Simon, If you are adding columns you will also need to add controls to the userform and add them to the code as will. The reason the list box is still showing 7 columns is because of the dynamic range 'outdata' The listbox is populated by a dynamic named range. In the project it is called 'outdata' =OFFSET(phonelist!$N$9,0,0,COUNTA(phonelist!$N$9:$N$10000),7) I you added a column you would adjust the range to suit 7 would change to 8. You would also need to adjust the listbox properties as show in the Videos. You will also need to adjust the double click (macro) code if the ID column is moved. Best wishes Trev •. First of all I'd like to thank you for sharing this valuable tutorial with the world and express my personal gratitude to you. I was inspired by your 'Simply the Best Excel Phone Book – Contact Manager' project and I decided to use it in my work, where I have to maintain a record of all the documents of a relatively small NPO. So I started almost from scratch as I built up the GUI, adding ease of use and intuitiveness to it, did some data validation and etc. And adding your code was the thing that brought life to all this, it was the bloodstream of it all. I was so excited and I wanted to enhance the functionality by adding a second criteria select field which applies a new filter to the pieces of information that the first one shows in the list box. I am afraid that this is tougher than me and I wouldn't be able to do it on my own. Your advice will be appreciated on solving this matter. With the due respect, Zlatin •. Hi, Trevor Thanks for sharing this valuable tutorial with us. I'm new to VBA, but have have followed your tutorials, which are absolutely informative and easy to follow, and have now completed a rough form. I've adjusted the tab order as per one of the above queries – thanks for that. I've two queries please: (i) How do I alter the font in each of the six boxes on the user form to say Times Roman, normal, not Italics. I'd be very grateful you could outline the code to add two or three more boxes on the user form. Many thanks Trevor, Regards, Roy •. Hi Roy, Thank if your communication. Each control that you add to a user form has a set of properties you can access these properties by right clicking the control in the VBA editor and choosing Properties. You will you will notice a property called Font that will allow you to change the font style and also the size and characteristics of the font. To add two more controls you will notice on the phonelist sheet that the columns G and H are empty. You could use these two columns to match the two new controls that you add to the user form. Because the user form runs an advanced filter to extract the data. The two new column headers would also need to be added to the copy to range of the advanced filter (columns U and V). You would then need to adjust the parameters of the advanced filter to accommodate the two new columns. DataSH.Range('B8').CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=DataSH.Range('L8:L9') _, CopyToRange:=DataSH.Range(' N8:T8') Instead of T8 the reference would now be V8. There is a dynamic named range that populates the listbox in the user form and it would need to be expanded to accommodate these two new columns. =OFFSET(phonelist!$N$9,0,0,COUNTA(phonelist!$N$9:$N$10000),7) because we have two new columns you would change these 7 two and 9. Have this would now allow the dynamic named range to accept the two new columns. In the properties of the listbox in the user form he would need to add the column count to now accept the new columns If you wish to view them. There may be a few other things that are necessary but this will get you started and give you some idea of what is happening. Please accept my very best wishes Trevor •. Hi Trevor, first i want to thank you for creating these amazing posts, the way you explain everything makes it look so easy. Hi Exionpt, I think I understand what you want to do. First of all the listbox that shows the results of the search is populated by a named range that picks up the results of a Advanced Filter. In this tutorial the advanced filter has one criteria. Advanced filters are truly awesome and you can run multiple criteria and you can add operators to those criteria as to pretty much filter anything that you want. It is possible to have what is called cascading data in a combo box. So when you select for instance a category then the items will appear in the next combo box or text box that are only the items for category. This is demonstrated in the tutorial below. It is good to understand the capabilities of advanced filters and I have a tutorial here that might help you understand what can be done. At the very least this should give you some food for thought., Please accept my best wishes Trevor •. Yes I am developing this project, but this time I created 2 Forms exactly the same and of course it will dump to 2 different sheets. When everything is working with the first form(edit, delete, add, everything), and start with the 2nd form. After the recording of 2nd macro and try if the 1st Form is still running I'm getting this error: 'the extract range has missing or invalid field name'. Is it because I can only record 1 advance filter macro? Thank you so much Trevor, hope you can still help me here.:D •. Hello Trevor, I want to know if it is possible to change some of the VBA coding to have your select field variable search in the middle of words/number. I added a select field that has a few different numbers and when I type in a number in the “search for”, I only am able to find what the first set of numbers are. EX: 44,42,41 (in the database column next to one person) if I search for 44, it will bring up the contact, but if I search for 42 or 41 nothing appears. How would I go about editing? Greatly appreciate any help, Natalie •. Hi Trevor, I LOVE your work and have purchased your books and working through your projects. Thank you so much for the time you have put into this. I am devouring your processes faster than I can chew, hence my problem. I have modified you CONTACT project for inclusion in my Rescue Squad. It is brilliant. I changed a category to ROLES which obviously has multiple entries. I would like to search the database for a key word and return the result to the ListBox1. So far I have developed a txtFind and cmdFindText to put a word in L9 and then search the database for the term but the results won't go the ListBox. I suspect the problem is the Criteria mismatch but I can't work out what should go there. If you have time, could you check the code below to point me in the right direction. Thank you once again. Trevor, your work is really an inspiration. Before I always hate excel as I am not familiar with its functions and its capability. But after watching some of your tutorials on MVB on the many things it can do for us. I was hook and now I love excel. I got this little problem and hope you would help me out with this error message I am getting every time i press get contact. 'The destination range is not large enough to accommodate all copied rows. Data below destination range will be lost. Continue copying anyway? After i click yes. Everything reads out on the listbox which is fine. But on the interface all the results filter is paste on the interface page. And when i tried my next search it just pick all the data and not filter it. Hope you will help me fix this problem?? Thanks Penioni •. Subscribe Now: Watch More: Inserting an address book into Microsoft Word is a great way to import information from a program like Outlook. Insert an address book in Microsoft Word with help from a certified career, small business and life coach in this free video clip. Expert: Crystal Williamson Filmmaker: Nick Laden Series Description: Microsoft Office is one of the most widely-used productivity suites for both the Mac OS X and Windows platforms. Get tips on Microsoft Office and Windows with help from a certified career, small business and life coach in this free video series. To resize a photo, you can click the image and use the corner boxes to resize it by 'dragging' it, making it larger or smaller. Or, if you need more precision, you can use the Format Picture dialog box: 1. Right-click the picture and select Format Picture 2. No results; 0. Find brochure templates in Publisher. Click Built-In > Brochures and click a template in one of the categories of brochure. In this tutorial you will learn how to make brochure in Microsoft Word. In this tutorial you will learn how to make. Create professional looking, full-color brochures using Xerox brochure templates. In the Format Picture dialog box, click the Size tab 3. You can use the Height and Width boxes at the top to enter a size in inches 4. You can also use the Height and Width boxes in the scale section to specify the size as a percentage 5. Deselect Lock aspect ratio if you don't want to retain the current width to height ratio 6. Click OK Changing Picture Layout Options. The Word program provides you with a variety of options for changing the layout of your picture. For example, you can have the text wrap around the picture, or you can insert the picture in line with the document text. To change the layout options, follow these steps: 1. Right-click the image 2. Select Format Picture 3. Open the Layout tab 4. Select ' Square', and click OK. This will allow you to click and move the image around the template easily, positioning the image exactly where you want it. For advanced options, such as the amount of space around the picture, click Advanced. Editing Text in Word Documents Editing text in Word is as easy as entering text in a blank document - just start typing! By clicking within the body of the document, you can add or delete text as needed. • First, highlight the text or block of text you want to copy. Then, select the Copy command using one of the following methods: • Select Copy from the Edit menu • Click your right mouse button while on the highlighted text, and select Copy from the right-click menu list • • Use the shortcut feature Ctrl C (hold down the Control button, while pressing the C button) and to paste what you have copied, press Ctrl V. Changing Text Color in Word To change the color of your text within your document, first click on the font color on the Formatting toolbar. From the Colors palette, select the color you would like to use. You can pick from Theme, Standard, or you an open up a full palette, to fine-tune your selection. Microsoft Blank Invoice Template. MS Spreadsheet Invoice Template in Excel and the Office online. Employed Invoice Template - 8+ Free Word, Excel, PDF. Blank Invoice template designed for professionals. This simple free template is available to print, download and save to your desktop. When it comes to performing calculations in a Word document, we tend to think of embedding or linking an Excel worksheet — but this can be overkill. Sometimes, a better approach is simply to insert a table in a document and perform the calculations in it. I am looking for a simple invoice for product and services hat vcan be easily setup to use for my home business. Download our free invoice templates for Word or Excel. Choose between five free invoice template designs and start sending invoices today. Blank Invoice - Download a free printable Blank Invoice template for Excel. Designed for printing and filling out by hand. Find other invoice templates. Word tables have a number of applications: staffing rotas, timetables, pricing charts, quotations, and the one I use most, invoices. It's easy to create an invoice that includes your business details, contact information, and logo, along with a table that itemizes the costs, parts, and labor; automatically calculates the totals and taxes; and presents a total amount payable. You can even include Fill-in fields to automatically prompt for customer information. Once you set up this invoice framework, save the blank form as a template, and you're in business. To generate an invoice, you just create a new document using the template, fill in the customer information, and enter the invoice amounts in the table. You can then update the fields that calculate tax and totals and print the invoice. To help you get started, I've created a that you can customize to fit your needs. Let's look first at some template-building basics; then, I'll explain how to modify and use my sample template. Laying out the heading The first step in building an invoice template is to design the heading you want to use for it. Once you've created a heading, save it so you can use it for other marketing material, such as flyers, price lists, and announcements. AutoText tip One convenient way to preserve an element such as a heading is to save it as AutoText. Just select the items that make up your heading and press [Alt][F3]. When Word presents the Create AutoText dialog box, enter a name and click OK. Then, whenever you need to insert the heading in a document, just position the insertion point marker where you want the heading to appear and type the AutoText name. By default, Word will offer to auto-complete the name, and you can press [Enter] to insert the heading. If this feature is turned off, just type the AutoText name and press [F3]. Creating the body of the document. Think about the wording you're going to use in your invoice. Be careful not to fall into grammatical errors that can make you and your business look unprofessional. In my template, I used an automatic Date field so that each invoice I create from the template will be correctly dated. Planning and inserting the table When you're ready to add the table to your template, display the Tables And Borders toolbar. As with the other toolbars available in Word, you can switch on this one from View| Toolbars. Most of the table options can be reached from this toolbar. Decide how many rows and columns you need in your table. You can always insert extra rows, but it is nice to start out with something you don't need to alter too much. Once you have planned the layout, click on the Insert Table button. You will see a dialog box where you can select the number of columns and rows in your new table. Entering the calculations. This Microsoft Word tutorial shows how to print a single envelope from the Envelopes and Labels dialogue box. Free Downloadable Envelope Templates. This product range includes the popular #10 envelope which measures 4 1/8' by 9 1/2'. Jan 30, 2014 Bright Hub. Leave a comment. Number 10 Envelope. Create a Family Tree With the Help of These Free Templates for Microsoft Office. Envelopes are designed to give the more finishing and professional touch to your cards. Those people who design their own invitation cards or writing a letter to someone, it is more likely that you will try to design envelope also. You may want to have a unique and good looking envelope which can give an attractive look to your card. A professionally designed envelope compels the reader to open it and read whatever is present inside an envelope. Envelopes can be prepared in different sizes depending on the size of the card you have prepared. There are many websites which have free envelopes designs to be used. These envelopes are the best alternative for you to going to market to get an envelope. Envelopes available on the internet saves a lot of money and it is also best to use when you want to have an envelope of your desired size. Envelopes can be best for invitations for wedding, birthday parties, Christmas cards, greeting cards and lots of other types of cards as well as letters. Advertisement The templates of an envelope are very easy to use. All you have to do is to choose the desired template for your card, adjust its size and then print it. You can print the template on any type of paper. Scrapbook papers and patterned or colored cardstock give more professional and beautiful look to your envelope but if you want to keep your envelop simple, you can also print the envelope template on the white paper. Before you print the template, you will be required to consider several things such as the size of the envelope that you want to have. Usually, the templates are available in standard form and are also available in irregular shapes. After printing the template, you can take a ruler to figure out whether the size of the envelope is according to your needs or not. If you have any doubt about the size, you can print the template of a bit bigger size than the desired one and then you can trim it down to the desired size. Usually, the invitation cards also have some standard sizes. For example, wedding invitation cards have a standard size of A2. The websites containing envelope templates contain envelope based on the standard size of the cards. For some websites, you will have to purchase the envelope templates, however; there are also some websites which enable you to use the ready-made envelope template free of cost. If you want the envelope to be in accordance with the size of your card, you can check the size of the available envelope template and then design the card according to it. Designing the envelope using the template is very easy to use. Size 10 (4 1/8 x 9 1/2 in) You can change size by following: Open MS Word > New File > Mailings > Envelopes > Options > Envelope size New Designs- 2017. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |