Copying data from two sheets.....

[davidingilbert]

Hey all -
I am attempting to create a macro to copy data from two different cells in my spreadsheet.

The data is eventually going to be pasted into an email.
Just for now, I need it copied only...

I tried doing one myself and that did not work.

I have tried a couple of ways I found online. But that is not working either.

Maybe I am missing something or having a bad day. I am also sure it is something small I maybe missing.
I would appreciate any help on this.

Thanks.
Dave

[Logit]

You will need to provide more information.

What data ?
What cells are being copied ?
Will the process be repeated in the future ?
Will the same cells be involved ?
Where on the new sheet, will the data be pasted ?
Is the data manually entered into the cells being copied or is it the result of formulas ?

etc. etc.

Posting a mock up of your sheets to be copied and the sheet to be pasted to would assist greatly. Actually sheets ... not images.

[davidingilbert]

Hey Log -
Sorry about that.

What I am after is from the attachment -
1. Copy all data from the tab "Condo Calculator"
2. Copy some of the data from the "House Calculator"
Fields A1 to K11
Fields C15 to C19
Field I18

I just want to be able to copy the data from both sheets and put into an email.
Thanks.
Dave

[Logit]

Two points ...

#1 : Do not use Merged Cells. Cells that are merged are extremely difficult to work with, if at all. More often than not merged cells will create more issues
than they solve. Please undo all of the merged cells and re-post your workbook.

#2 : What sheet is this data to be pasted to ? My initial thought was to create a new, empty sheet and paste the data there.

[davidingilbert]

Hey Logit - I don't have a "Holding Sheet" at present. I cannot create one.

Regarding the merged cells, I may be able to redo. Just will take time to re-create the spreadsheet and lose the merged cells.

Thanks.
dave