ArtofExcel
New Member
- Joined
- Jul 5, 2016
- Messages
- 17
I'm trying to make a macro that will copy a table with what will be an unknown length and paste it into a new location based on a reference text cell. Cell D1 will contain the text Week X where X is the current week of the year and the table is 5 columns wide (the source being in A:E starting in row 3). The macro needs to be able to search all of row 1 for the matching week number and paste the table with the top left corner 2 rows (so starting in row 3) directly under the reference text. the struggles I'm running into with this so far are:
1) Copying the full table with the varying length, I do not know how big the input will be so it needs to be able to adjust on every use
2) Finding the reference text in VBA (I tried using .find but it did not seem to work in any appreciable way)
3) Pasting the cells based off the reference text range found when it will be in the form of a variable and not something I can just do something like "A" & i type of manipulation on
Any guidance would be much appreciated! Thank you in advance!
1) Copying the full table with the varying length, I do not know how big the input will be so it needs to be able to adjust on every use
2) Finding the reference text in VBA (I tried using .find but it did not seem to work in any appreciable way)
3) Pasting the cells based off the reference text range found when it will be in the form of a variable and not something I can just do something like "A" & i type of manipulation on
Any guidance would be much appreciated! Thank you in advance!