1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Make cells repeat a set number of times

Hi all,

Back to my hostel!

We use spreadsheets for tracking groups, and some rooms sleep 2, some 4 and some 6.
We pre-populate the rooms for the leaders and then they fill in the names.

Is there a way of me setting it up for that if I pick room 6, it repeats it one more time, but if I enter Room 21, it repeats it 6 times.

Thanks in advance!

submitted by /u/Hot_Syrup_1774
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#natural language processing for spreadsheets
#Excel alternatives for data analysis
#generative AI for data analysis
#rows.com
#big data management in spreadsheets
#AI-native spreadsheets
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#predictive analytics in spreadsheets
#cloud-native spreadsheets
#real-time collaboration
#Excel alternatives
#spreadsheets
#repeat
#rooms
#Excel
#tracking
#cell
#times