Hi experts
I need your kind code for my small office work, i have set of data which is consistent same kind of data in 2 sheet, i want copy data from 2 sheet paste into different sheets depends upon Sheet Name {East,West,North,South,....}
Like copy from sheet rawdata1 and sheet rawdata2 paste into different sheet depends upon name in sheet cell range have command button
for e.g
Condition 1 : Rawsheet1 Column B have data south and Rawsheet2 Column B have data south, from both sheet all data south copy to south sheet, 1st range(A30:G30) 2ND RANGE(I30:O30)
Condition 2 : In sheet south In column C have states data when i click state wise command button corresponded states data will be in both range
please find the attachment
Hi Mani,
Instead of writing complex codes, try the solution attached, all you have to do is to refresh the Report if there is new data in the source tables.
Complex codes need come mostly from wrong design or improper use of built in excel tools.
