hello
I have this simple file if any body idea about how I can fill the empty row based on column from multiple textbox to sheet based on selected item from combobox please provide me
copy data from userform to empty row based on combobox
- alhagag
- Thread is marked as Resolved.
-
Have a look at the attached workbook.
-
Try the attached file. Click the "Insert Data" button.
-
-
-
The empty rows above the "TOTAL" row are necessary in order to update the formulas in that row and in column E after the data is inserted.
-
I have row is filled before the total and contain the formula
If you mean the row above the TOTAL, the file you posted has no data or formulas in the row above the TOTAL row except in column E which has a formula.
-
What do you want to happen when there's no more room to add an entry?
-
-
Let's say for FR-100 all 7 rows between BRAND and TOTAL are filled.
What should happen if the user tries to enter data for FR-100?
Should they be told there's not more room? Should the data go somewhere else?
-
That's kind of what my code but it does the row insertion before the rows are fully filled.
The reason for that is it's hard to determine when the rows are fully filled. -
-
-
It's not impossible, it's just kind of difficult due to the way you have things laid out.
Why not have a separate sheet for each item? -
Do you need to have a layout where each item has it's own 'section'?
-
I'm sure told you before that your workbook design is flawed. It looks like an Inventory workbook but your design is just making work.
You need one sheet to record incoming and outgoings and a sheet to summarise these transactions. You don't need VBA to do this
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!