Feb 16 2022 07:15 AM
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