John Caines
Well-known Member
- Joined
- Aug 28, 2006
- Messages
- 1,155
- Office Version
- 2019
- Platform
- Windows
Hello All.
I'm just trying to finish off a spreadsheet,, it's 95% done,,, but I really need help with 1 macro to finish it off, as it will be quite code intensive (For me anyway)
I would like to ask 1 question so I can clarify how the macro needs to be written.
My question is;
If for example I have a £ amount in cell K36 of £100, in a sheet called "Data Import"
And would like a macro button, that would export it to another sheet called Daily Targets and insert into Cell J24,,,, this can be easily achieved,,, I think so,, yes,,?
But,,,,,,,,,,,,,,,,
If J24 is a merged across cell,, IE is merged with K24,,, can this still be done in VBA?
Or,,, Does K36 have to be a merged across cell (As I could redo this sheet, so K36 is merged with L36,,,, so a merged cell is exporting to another merged cell?
I ask this because if you usually copy and paste cells into excel, and some are merged,, excel usually says via a pop up that the cell you are importing to is not the same size or shape,, (Or something to that effect)
If somebody could please just clarify this for me,, it would be most helpful,, so I know what I need to do/say regarding the new macro.
many thanks for all your time.
regards
john Caines
I'm just trying to finish off a spreadsheet,, it's 95% done,,, but I really need help with 1 macro to finish it off, as it will be quite code intensive (For me anyway)
I would like to ask 1 question so I can clarify how the macro needs to be written.
My question is;
If for example I have a £ amount in cell K36 of £100, in a sheet called "Data Import"
And would like a macro button, that would export it to another sheet called Daily Targets and insert into Cell J24,,,, this can be easily achieved,,, I think so,, yes,,?
But,,,,,,,,,,,,,,,,
If J24 is a merged across cell,, IE is merged with K24,,, can this still be done in VBA?
Or,,, Does K36 have to be a merged across cell (As I could redo this sheet, so K36 is merged with L36,,,, so a merged cell is exporting to another merged cell?
I ask this because if you usually copy and paste cells into excel, and some are merged,, excel usually says via a pop up that the cell you are importing to is not the same size or shape,, (Or something to that effect)
If somebody could please just clarify this for me,, it would be most helpful,, so I know what I need to do/say regarding the new macro.
many thanks for all your time.
regards
john Caines