
Active Member

June 15, 2022

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
1 Guest(s)
