Iteratively copy cells from one worksheet in a workbook to another worksheet in another wo

[amandeepsharma89]

Hello Everyone,
I am new to macros and wanted some help in automating few tasks. Expert guidance is welcomed (Excel 2010 question)

I have two workbooks "GHTR" and "GHTR_RAW". I want to copy data from different worksheets in GHTR to GHTR_RAW. GHTR has more worksheets than GHTR_RAW but worksheets in GHTR are present in GHTR_RAW. (GHTR worksheets are superset of GHTR_RAW worksheet)

I want to copy column A and column C from GHTR. The copied cell should start from cell A2 till the time it encounters a blank row and cell C2 till it encounters a blank row to GHTR_RAW cell B49 and downwards and Cell C49 and downwards. Also they should be copied to cell F49 and downwards and cell G49 and downwards

Basically,
GHTR:A2 till the time it encounters a blank row --> GHTR_RAW: cell B49 and downwards, cell F49 and downwards
GHTR:C2 till the time it encounters a blank row --> GHTR_RAW: Cell C49 and downwards, cell G49 and downwards

This needs to go from GHTR (worksheet abc) to GHTR_RAW (worksheet abc). This way it will iterate over all the worksheet in GHTR copy the data using the above logic and past it to the corresponding GHTR_RAW worksheet. e.g. GHTR: abc goes to GHTR_RAW: abc, GHTR: xyz goes to GHTR_RAW: xyz

Waiting for your expert replies.

Thanks,
Amandeep

[Richard Buttrey]

Hi,

Is this something you want to repeat many times, hence the suggestion of a macro? If it's not and a one off exercise then I'd just be inclined to do it manually. Yuo'll no doubt need to filter/copy/pastevalues.

If however you do need macros to automate it you'll need to upload the workbook so that we can see the request in context.

[amandeepsharma89]

Hi Richard,
I will have to do that for a lot. I have attached two excel sheets with what I want. As you can see in GHTR there is data in column A,C even after encountering a first blank row but I want to copy till one row above the first blank row occurrence. Also, it needs to find the same worksheet name in GHTR_RAW and copy it based on the above logic.