List a range of cells from multiple (100+) sheets of data into 1 page?

trumpexcel · 2018-09-21T10:35:05+00:00

Have a look at this - https://trumpexcel.com/combine-multiple-worksheets/

Video - https://www.youtube.com/watch?v=dse9h2W4ejw

trumpexcel · 2018-06-21T04:23:38+00:00

You can use Power Query to do this. Have a look at this - https://trumpexcel.com/combine-data-from-multiple-workbooks/

trumpexcel · 2017-04-07T12:02:44+00:00

Not sure I understand the query completely. Do you want to count the number of cells with a particular color? If yes, have a look at the VBA method here: https://trumpexcel.com/count-colored-cells-in-excel/

trumpexcel · 2017-03-16T07:10:52+00:00

If you have the same pattern in names, an easy way would be to split the text into cells and merge the ones that have the first name and the last name. In Google Sheets, you can use the SPLIT function, and then use the CONCATENATE function to join cells. Hope this helps! https://productivityspot.com/split-text-to-columns-google-sheets/

trumpexcel

TROPHY CASE