Issues carrying table/data over to different sheet with matching.
Hi,
I’m having trouble figuring out how to go about transferring information into another sheet based on matching criteria.
In one sheet I have columns of sets, reps, load, with the corresponding #s below (sometimes 2 or 3 rows depending on the week). My goal is to have these set/rep schemes named. That way, when I build a program on another sheet, I can simply click the name of the set scheme via a list (from data validation) and have the schemes auto-filled into the corresponding cells.
I’m unsure how to proceed with naming the data set of sets/reps/load (since there are multiple weeks to account for) or what formula to use to essentially copy and paste the data set to my preferred cells based on the matching name I choose.
For example, in Sheet 1, C3-H3 is Sets1, Reps1, Load1…Load2, C4:H6 are the prescribed numbers. How would I name this set? Then, in another sheet if I have a data-validated list cell (for the scheme), what formula would carry the information over into the new sheet?
Appreciate the help.
Hi, I’m having trouble figuring out how to go about transferring information into another sheet based on matching criteria. In one sheet I have columns of sets, reps, load, with the corresponding #s below (sometimes 2 or 3 rows depending on the week). My goal is to have these set/rep schemes named. That way, when I build a program on another sheet, I can simply click the name of the set scheme via a list (from data validation) and have the schemes auto-filled into the corresponding cells. I’m unsure how to proceed with naming the data set of sets/reps/load (since there are multiple weeks to account for) or what formula to use to essentially copy and paste the data set to my preferred cells based on the matching name I choose. For example, in Sheet 1, C3-H3 is Sets1, Reps1, Load1…Load2, C4:H6 are the prescribed numbers. How would I name this set? Then, in another sheet if I have a data-validated list cell (for the scheme), what formula would carry the information over into the new sheet? Appreciate the help. Read More