Within sheet 1 of my work book I have data relating to customers - the customers data appears under the customers name (example below). Each month the data changes and therefore the customer name does not appear on the same row as prior months as the data is not static. The headings for each data set i.e. Customer Name 1 (heading) appear in column B.
Within sheet 2 the data is fixed and therefore the rows wont change each month.
I need vba code which which on sheet 1 will find the text "Customer Name 1" for example insert 2 rows directly underneath the heading. Then copy and paste a range of data relating to Customer 1 from sheet 2 and paste as a picture (as the column sizes differ on sheet 2 to sheet 1) within the newly inserted rows on sheet 1. then repeat the process for customers 2 & 3. Is there a way to do this?
Customer Name 1 (heading in column B)
Column B Column C Column D
Date Product Price
xx xxxx xxxxx
xx xxxx xxxxx
Customer Name 2 (heading in Column B)
Column B Column C Column D
Date Product Price
xx xxxx xxxxx
xx xxxx xxxxx
xx x xx xxxxx
Customer Name 3 (heading in Column B)
Column B Column C Column D
Date Product Price
xx xxxx xxxxx
Within sheet 2 the data is fixed and therefore the rows wont change each month.
I need vba code which which on sheet 1 will find the text "Customer Name 1" for example insert 2 rows directly underneath the heading. Then copy and paste a range of data relating to Customer 1 from sheet 2 and paste as a picture (as the column sizes differ on sheet 2 to sheet 1) within the newly inserted rows on sheet 1. then repeat the process for customers 2 & 3. Is there a way to do this?
Customer Name 1 (heading in column B)
Column B Column C Column D
Date Product Price
xx xxxx xxxxx
xx xxxx xxxxx
Customer Name 2 (heading in Column B)
Column B Column C Column D
Date Product Price
xx xxxx xxxxx
xx xxxx xxxxx
xx x xx xxxxx
Customer Name 3 (heading in Column B)
Column B Column C Column D
Date Product Price
xx xxxx xxxxx
Last edited: