VBA copying a range based on contents of a cell

**soso123** · 08-23-2011, 07:19 PM

Hi All,

I have attached excel file.
the data sheet is data get from database.
i need help with code that look for word "Itemized" (is colored in red ) and select the table below this word and copy it to a new sheet and rename the sheet as the mobile of that table.
example of need table are also found in two sheets next to data sheet.

Many thanks for your help

**tlafferty** · 08-23-2011, 07:26 PM

Some questions:
1) Will there be more than one itemized table?
2) Will there be more than one mobile number?
3) Do you want to move the table to its own sheet, or copy it to its own sheet leaving the original on the Data sheet?

**soso123** · 08-23-2011, 07:55 PM

Thanks for the reply .

1)Will there be more than one itemized table? yes for each mobile number
2) Will there be more than one mobile number? yes, but i need just to copy the table of mobile with utemized table only.
3) Do you want to move the table to its own sheet, or copy it to its own sheet leaving the original on the Data sheet? copy each table to new sheet with mobile number as name of the sheet

I hope that i answered your questions ....
Kindly check the attached file

Thanks again for your help

**efernandes67** · 08-23-2011, 10:09 PM

Here is a way, I hope it woks for you

Please Login or Register  to view this content.

Elio Fernandes

**soso123** · 08-25-2011, 02:12 PM

Thanks a lot... the code works fine....

what should i do to save each new sheet as a xls file.

VBA copying a range based on contents of a cell

LinkBack

Thread Tools

Rate This Thread

Display

VBA copying a range based on contents of a cell

Re: VBA copying a range based on contents of a cell

Re: VBA copying a range based on contents of a cell

Re: VBA copying a range based on contents of a cell

Re: VBA copying a range based on contents of a cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions