![]() Select cell B13 and enter the formula shown below.Įxplanation: If cell A13 is empty, the formula returns an empty string. Now you can add as many new products as you want.Ĩ. Manually change the 5 to 1048576 (or any other large number) to include more cells. Click in the Source box and select the range A2:A5 on the Products sheet.Ħ. On the Data tab, in the Data Tools group, click Data Validation.ĥ. On the Invoice sheet, select cells A13 through A31.ģ. On the Products sheet, type the product information.Ģ. The same tricks have been used for the client information.ġ. ![]() Below we'll explain how we automated the entry of the product information.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |