Hi Guys
I have a data source with information that changes. The layout stays the same in other words the columns will always be the same but the rows will either be more or less. And some cell names (Sub-headers if you will) will change
This is the source on workbook "Master" Sheet 1 I want to copy Columns A:K from row 6 to the end of the data below. (Changes every time). This will be pasted in another workbook "Sales"Sheet 1 Range A2. Columns L:W from row 6 to the end of the data range in the Master Workbook (which might have some blank cells) will be copied and pasted in Workbook "Sales" Sheet 1 from X2:AI. I hope this makes sense.
Then as a "would be nice to do" the names in L3:W3 in the "master" Workbook should be added to the names in Workbook "Sales" X1:AI - So basically it would look something like this:
ActiveCell.Value(This is Workbook "Sales" X1) = "Gr Sales" & " " & "MASTER".Sheets(Sheet1).Cells(3,12).Value "Gr Sales being the constant and the Name will change everytime the master data is updated.
I have a data source with information that changes. The layout stays the same in other words the columns will always be the same but the rows will either be more or less. And some cell names (Sub-headers if you will) will change
This is the source on workbook "Master" Sheet 1 I want to copy Columns A:K from row 6 to the end of the data below. (Changes every time). This will be pasted in another workbook "Sales"Sheet 1 Range A2. Columns L:W from row 6 to the end of the data range in the Master Workbook (which might have some blank cells) will be copied and pasted in Workbook "Sales" Sheet 1 from X2:AI. I hope this makes sense.
Then as a "would be nice to do" the names in L3:W3 in the "master" Workbook should be added to the names in Workbook "Sales" X1:AI - So basically it would look something like this:
ActiveCell.Value(This is Workbook "Sales" X1) = "Gr Sales" & " " & "MASTER".Sheets(Sheet1).Cells(3,12).Value "Gr Sales being the constant and the Name will change everytime the master data is updated.