Why do you need to duplicate data, it is generally totally unnecessary. Where do you want to add the Row, attach a small example workbook.
Why do you need to duplicate data, it is generally totally unnecessary. Where do you want to add the Row, attach a small example workbook.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Ok, I have a list iof customers and info in the tabs of Chi and Mex. In the tab Master I have a consolidation of all my data. The tab Master has a formula to modify automatically whatever changes I make in the other 2 tabs. However, when i add a new customer in Chi or Mex, I have to copy it and paste it in Master.
Now imagine doing that when you have 10 worksheets and many many customers on them.
Hope this helps
You only need one sheet of data, you can easily use AutoFilter on the countries column
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks