knittelmail
New Member
- Joined
- Jun 28, 2023
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Hello and thank you in advance.
I am trying to pull information from one sheet "Report" and put it into a different sheet "Formulas". Unfortunately the cell locations in the two sheets are not identical so I can't do a simple copy and paste. I can do a lot of complicated cutting and pasting, but I am sure that VBA can help me simplify the process. I am too new to VBA and just can't seem to figure it out. Please help.
Here is a summary of what I am trying to do:
Please let me know if this isn't clear or is impossible
with a range of A21:A123 in worksheet "Report"
starting with A21 search down to the first blank cell (lets call it A36)
select a range of cells based on the cells in the search that have contents
lets say that A21-A35 have something in them - the range to select would be A21:Z35
copy A21:Z35 and paste it to a worksheet "Formulas"
the upper left cell of the range to paste into is specific in Sheet "Formulas" A28
the paste need to be paste special with values only and skip blanks so I don't overwrite the formulas in "Formulas"
skip down to the next non-blank cell and repeat
start with A37 "Report" and search to the next blank
select the range from A37:Z**
copy and paste those cells into "Formulas" at A55
repeat to the bottom of A21:A123
I am trying to pull information from one sheet "Report" and put it into a different sheet "Formulas". Unfortunately the cell locations in the two sheets are not identical so I can't do a simple copy and paste. I can do a lot of complicated cutting and pasting, but I am sure that VBA can help me simplify the process. I am too new to VBA and just can't seem to figure it out. Please help.
Here is a summary of what I am trying to do:
Please let me know if this isn't clear or is impossible
with a range of A21:A123 in worksheet "Report"
starting with A21 search down to the first blank cell (lets call it A36)
select a range of cells based on the cells in the search that have contents
lets say that A21-A35 have something in them - the range to select would be A21:Z35
copy A21:Z35 and paste it to a worksheet "Formulas"
the upper left cell of the range to paste into is specific in Sheet "Formulas" A28
the paste need to be paste special with values only and skip blanks so I don't overwrite the formulas in "Formulas"
skip down to the next non-blank cell and repeat
start with A37 "Report" and search to the next blank
select the range from A37:Z**
copy and paste those cells into "Formulas" at A55
repeat to the bottom of A21:A123