ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Template Wizard with Data Tracking (https://www.excelbanter.com/excel-discussion-misc-queries/84211-template-wizard-data-tracking.html)

MC

Template Wizard with Data Tracking
 
I have been able to set up a form and datbase with the template wizard. The
only problem is that it only captures data from one column. Example below:

Item # 1 Item # 2 Item # 3
Date xxx xxx xxx
Cost xxx xxx xxx
Profit xxx xxx xxx

I can succesfully get the information from Item # 1 column but not from
Items 2&3. Itried expanding the range to include items 2&3 but an error
message appears and says that I can only assign one cell for that range.
Do I need to create a seperate form for Items # 2& 3 and then add them to
the database?
Any help will be appreciated.




All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com