Forum Discussion
Add a new customer to a list of customers in a table
However, I prefer to have this data in rows instead of columns so it's much easier to copy data from the Selected New Customer to my list of all customers.
Sorry,I can not understand which one is the destiantion table.
why does List of all custermers list all items in multiple rows rather than columns?
In former threads,the new customer has been list in multiple rows.
We have tried to transpose them save to columns in a row.
Can you share your source table and expected result?
G15 merge cell Panes?
I15 merge cell External Screen?
If you use merge cell,it is not easy for further calculation or analysis.
When you save your data, please refer the source table layout for a pivtot table.
New customers are added to the New Customer sheet. I then enter window washing or solar panel cleaning details on their respective worksheets. Once that is done I come back to the New Customer sheet and click on a button to run a macro copy the new customer's details to the All Customers sheet, name, address...to number of "Hard" solar panels.
How do I do this with all data in 1 row?
So, how do I get "arr" to refer to B18:M18 so I add a new customer and their window/solar details to my list of All Customers?
B18:M18?
G18:M18 ALL Empty.
Why refer to blank cells (G18:M18)
their window/solar?
Window Tally Sheet has only one row data besides first header row.
Sheet solar too.
What do you mean their window/solar?