Digitization of Data and Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-2088162%22%20slang%3D%22en-US%22%3EDigitization%20of%20Data%20and%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2088162%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20form%20that%20I%20scribble%20in%20when%20counting%20loose%20threads.%26nbsp%3B%20I%20am%20trying%20to%20digitize%20that%20form%20while%20keeping%20it's%20current%20design%20for%20the%20sake%20of%20simplicity.%26nbsp%3B%20I%20desire%20to%20put%20text%20boxes%20around%20a%20circle%20at%20top%2C%20left%2C%20bottom%20and%20right-then%20I%20enter%20a%20count%20in%20each%20text%20box%20and%20have%20Excel%20subtotal%20in%20the%20center.%26nbsp%3B%20I%20would%20have%20a%20total%20of%2012%20sets%20of%205%20circles%20each.%26nbsp%3B%20Eventually%2C%20I%20will%20add%20the%20subtotals%20together%20in%20sets.%26nbsp%3B%20I%20am%20able%20to%20draw%20text%20boxes%20into%20the%20existing%20form%2C%20but%20I%20haven't%20been%20able%20to%20get%20Excel%20to%20get%20the%20values%20from%20the%20four%20text%20boxes%20and%20add%20them%20up.%26nbsp%3B%20I%20can%20do%20all%20kinds%20of%20operations%20with%20data%20in%20columns%20and%20rows%2C%20but%20I%20don't%20seem%20to%20be%20able%20to%20do%20basic%20math%20operations%20with%20data%20that%20is%20scattered.%26nbsp%3B%20Any%20suggestions%20would%20be%20greatly%20appreciated.%26nbsp%3B%20I%20am%20happy%20to%20watch%20all%20the%20tutorials%20out%20there%2C%20but%20time%20is%20limited.%26nbsp%3B%20If%20anyone%20can%20provide%20hints%20that%20will%20get%20me%20closer%20to%20my%20goal%2C%20it%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2088162%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a form that I scribble in when counting loose threads.  I am trying to digitize that form while keeping it's current design for the sake of simplicity.  I desire to put text boxes around a circle at top, left, bottom and right-then I enter a count in each text box and have Excel subtotal in the center.  I would have a total of 12 sets of 5 circles each.  Eventually, I will add the subtotals together in sets.  I am able to draw text boxes into the existing form, but I haven't been able to get Excel to get the values from the four text boxes and add them up.  I can do all kinds of operations with data in columns and rows, but I don't seem to be able to do basic math operations with data that is scattered.  Any suggestions would be greatly appreciated.  I am happy to watch all the tutorials out there, but time is limited.  If anyone can provide hints that will get me closer to my goal, it would be greatly appreciated.

 

 

 

1 Reply

@RoxieG 

I don't think I am the right person to help you with your plans.

But I know that if you insert an Excel workbook (without sensitive data)

and explain your plan there in detail,

you would get a suggested solution much faster.

Of course, knowing your Excel version and operating system

would be of great advantage when sending the proposed workbook.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)