Forum Discussion

Lars W's avatar
Lars W
Copper Contributor
Dec 08, 2017

Moving data according to field (date)

Hello

 

I'm having a problem that i really cant explain other than with a picture, making me unable to search for a solution, or a function to use. 

 

I believe (and hope!) its quite simple.

 

1. I need to input data in the orange field daily, moving/updating the data into the blue fields, according to the chosen date (green).

 

2. I would like to be able to change the date (green) by using buttons, gaining access to the blue data in the orange field (so it goes blank for a new day, or is possible to change if needed) 

 

(It will of course have its own sheet, and be a lot larger) 

 

Hope someone can help me :) 

  • Lars,

     

    I told you that this app depends on fixed cell references, any change in it, the app won't work correctly!

    So you have to adjust the source code of the app to adapt the new changes!

    I cannot make it absolute dynamic!

    Anyway, I've modified the app to adapt to the new changes you've made!

     

    NOTE: You can add new dates to the table as below screenshot, the app is dynamic from this side!

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    You may see it easy!

    You don't know how difficult is this!

    Anyway, just upload the Excel workbook, I'll try to help you!

    • Lars W's avatar
      Lars W
      Copper Contributor

      Hello Haytham

      Yeah after searching far and wide i was scared that it was the case.

      But i am very grateful that you will try and help :) 

       

      I have added my workbook. 

      • Haytham Amairah's avatar
        Haytham Amairah
        Silver Contributor

        I attached the app for you!

         

        Notes:

        The app depends on fixed cell references!

        Any change in it, the app won't work correctly!

        Ex. Don't change the date location from cell C1!

         

        I've used the XLS file extension because this community doesn't allow us to upload XLSM files extension, but can convert the file to XLSM file extension after you download it on your device.

         

        You cannot save it in XLSX file extension because this extension doesn't allow you to save the macros and VBA projects!

         

Resources