copy data from main sheet to respective sub sheets

Hi sshanku1985 and welcome to the forum.
We need a sample xls file with your data to understand it a bit better.
You can attach a sample workbook by clicking on "Go Advanced" under the message area and then on the Paper Clip Icon above the message. This will open a dialog box to attach your sample file. You problem doesn't seem that hard but typing in the data is a pain.

This macro will do it "on demand". Place into a normal code module in the VBEditor (Insert Module) and attach to a button on DAILY SALES if you wish.

It will clear the current report on each secondary sheet then paste in all the rows that exactly match that sheetname in column A.

Please Login or Register  to view this content.

That's such an odd request for a question that is clearly posted in the programming forum.

Hi,

Try this. Name the Range of all your Daily Sales with something like DataTable. Then create an Advanced Filter Criteria on each tab as shown in the attached. Go to the tabbed page and perform an Advanced Filter and for the range, type in DataTable, use the criteria on the top of that sheet and set the output to A4 on that sheet.

You won't even need formulas if you do this method. You will have to name the range of your data on the Daily Sales sheet and perform Advanced Filters.

See the attached.

Hi,
After posting the last attached, I decided to make it better. You don't really need separate tabs for each customer. You simply need to change the customer name in cell A2 and recalculate the advanced filter. I recorded a macro to do this and put a button on the worksheet to perform the filter. Another improvement is a Dynamic Named Range on the data. I created a DynamicDataTable name that will expand the size of the table depending on how many lines are in your data.

Find the attached.

I wouldn't do what you've described with formulas.

Very few things in this world are done "automatically". Formulas are what you mean but Microsoft invented Database functions, Auto Filters, Advanced Filters and finally Pivot Tables because SumProduct and Array Functions just can't do everything.

The real hard part is to understand the easiest way and follow it.

I'm sure you can Google many fine resources. I get most of my learning from interacting here on the forums with people regarding real-world needs.

When you have a real-world need, try turning on the macro-record and letting it record you doing something you can do manually. Then try the resulting code and see if it works for you in the same situation on a different data set.

Then post that macro here on the forum with your sample workbook and let people here revise it for you. What happens here is now you have two macros to compare. The one you created you fully understand because it's a macro of what you did, so when you compare that to a better written macro you will understand the new things you see much more quickly.