ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Search and Copy between Cells with unique data (https://www.excelbanter.com/excel-discussion-misc-queries/219064-macro-search-copy-between-cells-unique-data.html)

david@damprodu

Macro Search and Copy between Cells with unique data
 
Hi there,

I'm trying to write a macro in excel that will search an imported text file
for cells/data between two cells (could be any) with the words 'section data'
and 'end section'

it will then copy the information into a new worksheet - any ideas?

Gary''s Student

Macro Search and Copy between Cells with unique data
 
If there are some empty cells between the two markers, do you want them
copied as well??
--
Gary''s Student - gsnu200831


"david@damprodu" wrote:

Hi there,

I'm trying to write a macro in excel that will search an imported text file
for cells/data between two cells (could be any) with the words 'section data'
and 'end section'

it will then copy the information into a new worksheet - any ideas?


david@damprodu

Macro Search and Copy between Cells with unique data
 
erm..... no

sorry for delay

"Gary''s Student" wrote:

If there are some empty cells between the two markers, do you want them
copied as well??
--
Gary''s Student - gsnu200831


"david@damprodu" wrote:

Hi there,

I'm trying to write a macro in excel that will search an imported text file
for cells/data between two cells (could be any) with the words 'section data'
and 'end section'

it will then copy the information into a new worksheet - any ideas?



All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com