Questions

Answer for:

Sharing parts of Spreadsheet data

Message 2 of 5

View entire thread
+
0 Votes
databaseben

it depends on how the intricated the spreadsheet is:

one of the simpliest methods is to use the filter capability in excel.

first you will need add a column to use in indexing. the column will contain the initials of the country and each row will essentially be marked with country it pertains to.

next apply the filtering feature via the menu bar.

then select the country from that column, and then only those rows will be listed on the sheet while the rest will be hidden - that is until you remove the filter criterion.

next print the revised spreadsheet as a pdf and email away.