Trying to see if a scenario is worth pursuing. (sorry for the long read)
I have a workbook with two work sheets.
In worksheet one I have dates with 10 names (and 6 other columns A:H in total) each name may have 10 rows of information.
(So Apples (eg) would appear 10 times) The two points of reference would be the name and week number.
In sheet two I have a list of the names which would be used to lookup the data and copy it to sheet two
under the relevant name and week number formatted 8 columns by the number of rows for the name that week.
The raw data would change to add more week numbers as it was refreshed ready to be inserted into sheet two.
which would move to eg week two, I was thinking by way of the macro "moving" over a couple of columns.
Or would it be better having the data so that each name had x columns down the page (so 8 columns wide for each name) as opposed to data for that
name going across the page? (with 10 rows)
Is the above possible with a macro?
I have a workbook with two work sheets.
In worksheet one I have dates with 10 names (and 6 other columns A:H in total) each name may have 10 rows of information.
(So Apples (eg) would appear 10 times) The two points of reference would be the name and week number.
In sheet two I have a list of the names which would be used to lookup the data and copy it to sheet two
under the relevant name and week number formatted 8 columns by the number of rows for the name that week.
The raw data would change to add more week numbers as it was refreshed ready to be inserted into sheet two.
which would move to eg week two, I was thinking by way of the macro "moving" over a couple of columns.
Or would it be better having the data so that each name had x columns down the page (so 8 columns wide for each name) as opposed to data for that
name going across the page? (with 10 rows)
Is the above possible with a macro?