Excel VBA Makro Solution
Budget: €30 – €250 EUR
I have one list on each of two worksheets that are basically to be considered a total list.
In the first row is the work row, there run different macros and functions depending on the cell. In the lower part only everything is listed. (some cells have to take over format conditions, others not).
Startup problem:
My workbook currently has the problem of returning "No feedback" if you add a new row. The problem would need to be solved.
Besides that, I need the following macros:
1) ("Seite 1" and "Seite 2" Image)
When I finish editing a row, (via Button) the list should move down and in row 5 the entry from the working row appears.
If there is already an entry in the list below, which has the same name as in the working line (a cell for comparison), the old entry should be replaced by the working line instead of in line 5. (updated).
2) ("Seite 2" Image this should also happen in "Seite 1" at the same time)
I have placed a button at each row, which contains the name of the entry, and which should have the function to copy the row in which the button is located to the top of the work row (i.e. only the cells that do not contain formulas).
--
I am quite good with VBA codes, but unfortunately I have not found a simple solution to my problem, so now I need some more professional help. Small things I can fix myself, important would be only that the folder works again and I can work with the function so that I can apply it to all rows.
In the first row is the work row, there run different macros and functions depending on the cell. In the lower part only everything is listed. (some cells have to take over format conditions, others not).
Startup problem:
My workbook currently has the problem of returning "No feedback" if you add a new row. The problem would need to be solved.
Besides that, I need the following macros:
1) ("Seite 1" and "Seite 2" Image)
When I finish editing a row, (via Button) the list should move down and in row 5 the entry from the working row appears.
If there is already an entry in the list below, which has the same name as in the working line (a cell for comparison), the old entry should be replaced by the working line instead of in line 5. (updated).
2) ("Seite 2" Image this should also happen in "Seite 1" at the same time)
I have placed a button at each row, which contains the name of the entry, and which should have the function to copy the row in which the button is located to the top of the work row (i.e. only the cells that do not contain formulas).
--
I am quite good with VBA codes, but unfortunately I have not found a simple solution to my problem, so now I need some more professional help. Small things I can fix myself, important would be only that the folder works again and I can work with the function so that I can apply it to all rows.