Create insertion cell

Occasional Visitor

Greetings,

not sure if what i will be sharing has been discussed before or not

hopefully someone will be able to help me with 

i am trying to create an excel file as data entry

My goal is to create two sheets in this file let's call the first Amount , the second is Detailed

the first (Amount) should have only one cell that i need to write down the data

the second (Detailed) should have multiple cells , and each cell should read from the cell in the (Amount) and after the data has been read by cells , automatically it will move the next cell in the (Detailed)

how that might be possible to be done knowing the Excel has a limitless abilities to create functions 

Thanks guys

0 Replies