Combine Calculate in a cells with several calculate in that cell and after that another calculate based on that cell

[Unexpc]

Hi guys
i have main problem and if you solve this, solve my main problem and helped me to calculate any of numbers that i do this in many hours
this is my problem
i have this worksheet that you see before, in first i said that belong to text, but that have information for main calculate, better say
in one cell i write information with this format : Give (+ Value) or Receive (-Value) ,G Or M, Text, Number, Percent or Thousands or Hundred (if Give and G and Percent: Percent that multiply to Number that written before this (if i not write anything in this part, multiply with 1), if Give and G and Thousands: Thousand multiply with number, if Receive and G and Percent: Percent multiply with number, if Receive and G and Hundred: Hundred multiply with number and then divide 750, for Give M that all this value sum and fill in specific columns that i say in below but for Receive M, if write MM after that calculate: Number multiply MM and divide 4.3318 if not write like Give M Calculate)
This fill in Column A
Columns B:C fill with Text without calculate
but in Column D
This fills with SUM of Gives and Back (+ Value) Calculates from G
in Column E
fills with SUM of Receive (- Value) Calculates from G
in Column F
fills with SUM of Gives (+ Value) Calculates from M
in Column G
fills with SUM of Receive (-Value) Calculates from M
and a point, i can't split information that belong one cell, because all of the info about a day and should write all info in one cell

 

[Unexpc]

1. if only problem is scroll down. do it with CTRL+ down Arrow

yes i use that but it down and down each customer

2. if you persist to do it with macro, which sheet you want to hide rows on it?

Work and Paper

 

[maabadi]

For problem with
i use that but it down and down each customer
Use CTRL+End Key
For MacroTry this:
BookT.xlsm

 

[Unexpc]

For problem with
i use that but it down and down each customer
Use CTRL+End Key
For MacroTry this:
BookT.xlsm

This is worked! Thank You...

 

[Unexpc]

:

Hi again mabaadi
i have problem with Paper sheet
three function does wrong
1. in Dashboard, Shows the zero for columns O,P,Q after insert two customers
2. when insert rows or deleted, after last customer placed white rows and not hidden
3. can't print from Paper sheet and shows an error

Book T=T.xlsm

drive.google.com

this is the last example file from you and you can test with it (this basically file and i copied codes from this file and use)

 

[Unexpc]

3. can't print from Paper sheet and shows an error

mabaadi ignore this, the cells from column A in paper i didn't fill it. i should fill them then this work correctly
but with 1 & 2 i still have problem
with Paper sheet
two functions does wrong
1. in Dashboard, Shows the zero for columns O,P,Q after insert two customers
2. when insert rows or deleted, after last customer placed white rows and not hidden

Book T=T.xlsm

drive.google.com

this is the last example file from you and you can test with it (this basically file and i copied codes from this file and use)