Automatically move data to a new sheet

[Strawsb]

I was wondering, if it was possible to create a cell in one sheet, where after data is entered, will move it to another sheet. Additionally, the data in the cell, after the transfer to another sheet is made would delete itself. Once the data is entered, sent to another sheet and deleted, next time data is entered into the same cell, it would be sent into a row below the cell that the first piece of data would be in. Therefore, after I enter data, [for example] press enter, then go back to input some more data, after a while there would be a long list in another sheet. The last feature of the problem (it would be something extra really) is that the function/macro is to be time dependent - during one month the data would stack up in one column, after the next one begins, the next column will automatically start all over.

The idea is to create a budget book - where on the main page I would only have to enter the value in a specific box, the value then would be automatically sorted into the right row and column in another sheet, after the month/week ends, data would start to stack up in a column devoted to a new month/week.

Thanks for any help, really stuck at this point - of course the data could be entered manually in different sheets, but it proved to be too complex to be useful. The book has to enable quick input.

[Bernie Deitrick]

Note that all you really need to do is enter the date and value you want into a list, and then you can apply filters, use pivot tables, etc. to see your data the way you want without having it moved to other sheets.

Still, it can be done, but you left out a lot of details, like how many and which cells, how your sheets are named, how the date is determined (entered or assumed to be current), etc.

But it is certainly feasible - so let's say that you have sheets named Jan Feb Mar Apr, etc. and you want any value entered in range B4:B10 to be moved to the bottom of column A, choosing the sheet based on today's date.

Copy this code, right-click the sheet tab, select "View Code" and paste the code into the window that appears. Save the workbook as a macro enabled .xlsm and any single cell entry in that range will be moved. Of course, the macro can do almost anything, so if you need it to be changed, post back.

Please Login or Register  to view this content.